Star

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.