The string used for representing the set of all the values of a field in the database can be set through the star statement. It affects the subsequent LOAD and SELECT statements.
Syntax:
Star is[ string ]
Arguments:
| Argument | Description |
|---|---|
| string |
An arbitrary text. Note that the string must be enclosed by quotation marks if it contains blanks. If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new star statement is made. |
Example:
The example below is an extract of a data load script featuring section access.
Star is *;
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, SALES
USER, USER2, U2, WAREHOUSE
USER, USER3, U3, EMPLOYEES
USER, USER4, U4, SALES
USER, USER4, U4, WAREHOUSE
USER, USER5, U5, *
];
Section Application;
LOAD * INLINE [
SALES, WAREHOUSE, EMPLOYEES, ORDERS
1, 2, 3, 4
];
The following applies:
- The Star sign is *.
- The user USER1 is not able to see the field SALES.
- The user USER2 is not able to see the field WAREHOUSE .
- The user USER3 cannot see the field EMPLOYEES.
- The user USER4 is added twice to the solution to OMIT two fields for this user, SALES and WAREHOUSE.
- The USER5 has a “*” added which means that all listed fields in OMIT are unavailable. The star sign * means all listed values, not all values of the field.
- The user USER5 cannot see the fields SALES, WAREHOUSE and EMPLOYEES but this user can see the field ORDERS.