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 or a view
descriptor. The LISTINFO information is written to your SAS log.
An editing statement,
such as LISTINFO, 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 LISTINFO statement
is especially helpful for subfields, superfields, and descriptor data
fields. It shows the ADABAS level, ADABAS name, length, data type,
and first-last character positions for a given DBMS column.
When you are creating
an access descriptor,
*NON-DISPLAY* appears
next to the column description for any column that has been dropped.
When you are creating a view descriptor,
*SELECTED* appears next to the column description for columns that you have
selected for the view.
The LISTINFO statement
can take one of the following arguments:
lists all the DBMS
columns in the file, the ADABAS levels, the lengths, ADABAS names,
the data types, and the first-last character positions.
lists the DBMS columns
that are selected for the view descriptor, along with the ADABAS levels,
ADABAS names, the lengths, the data types, and the first-last character
positions. Any columns that are dropped in the access descriptor are
not displayed. The VIEW argument is valid only for a view descriptor.
lists the specified
DBMS columns, the ADABAS levels, ADABAS names, the lengths, the data
types, the first-last character positions, and whether the column
has been selected or dropped. If the column name contains special
characters or national characters, enclose the name in quotation marks.
The column-identifier
argument can be either the column 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 column 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;