LISTINFO Statement

Shows additional data field information.

Type: Optional statement
Applies to: access descriptor or view descriptor

Syntax

LISTINFO ALL | VIEW | <"> column-identifier-1<">
<...<"> column-identifier-n<"> > ;

Details

The LISTINFO statement shows additional data field information for one or more DBMS columns in the descriptor. The LISTINFO statement can be used when creating an access descriptor or a view descriptor. The LISTINFO information is written to your SAS log.
The LISTINFO statement is especially helpful for key fields. It shows the CA-Datacom/DB short name as well as all the columns and levels that make up the key.
The LISTINFO statement can take one of the following arguments:
ALL
lists the field composition of all the DBMS columns in the file.
VIEW
lists the field composition of the DBMS columns selected for the view descriptor. Any columns that are dropped in the access descriptor are not displayed. The VIEW argument is valid only for a view descriptor.
column-identifier
lists the field composition of the specified DBMS columns. If the column name contains special characters or national characters, enclose the name in quotation marks.
The column-identifier argument can be either the CA-Datacom/DB field name, the positional equivalent from the LIST statement (which is the number that represents the column's place in the descriptor), or a list of names or positions. For example, to list information about the fifth column in the descriptor, submit the following statement:
listinfo 5;
Or, to list information about the fifth, sixth, and eighth columns in the descriptor, submit the following statement:
listinfo 5 6 8;