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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?