LISTOCC

LISTOCC

Lists occurrences for repeating data fields.

Optional statement

Applies to: access descriptor or view descriptor

Syntax
Details

Syntax

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

Details

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

The column-identifier argument 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 quotes. The column-identifier must be a repeating field.

Chapter Contents
Previous
Next
Top of Page

	Optional statement
Applies to:	access descriptor or view descriptor