LISTOCC Statement

Lists occurrences for multiple value fields.
Type: Optional statement
Applies to: access descriptor or view descriptor

Syntax

LISTOCC column-identifier-1 <... column-identifier-n> ;

Details

The LISTOCC statement lists all the requested occurrences for the specified multiple-value fields along with information such as the ADABAS level, the SAS variable name, the occurrence number, the SAS variable format and informat, the DB content, the descriptor type, and whether the occurrence has been selected or dropped. The LISTOCC statement can be used when creating an access descriptor or a view descriptor. The LISTOCC information is written to your SAS log.
If you use an editing statement, such as LISTOCC, it must follow the CREATE statement and the database-description statements when you create a descriptor. See CREATE Statement for more information about the order of statements.
The LISTOCC statement takes the following argument:
column-identifier
can be either the column name or the positional equivalent from the LIST statement, which is the number that represents the column's place in the descriptor. For example, to list occurrences for the fifth column in the descriptor, submit the following statement:
listocc 5;
The column-identifier must be a multiple-value field.