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;