The LISTOCC statement lists all the occurrences for the specified repeating fields
along with information such as the CA-Datacom/DB level, the SAS
column name, the occurrence number, the
SAS column format and informat, the DB content, 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.
The LISTOCC statement
takes the following argument:
column-identifier
can be either the CA-Datacom/DB
field 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;
If the
DBMS column name contains special characters or national characters, enclose the name
in quotation
marks. The column-identifier must be a
repeating field.