Shows additional data field information.
|
Optional statement
|
| Applies to: |
access descriptor or view descriptor
|
| Default: |
ALL
|
LISTINFO <ALL | VIEW |column-identifier-1
<...
column-identifier-n>>;
|
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
for more information on 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:
-
ALL
-
lists all the DBMS columns in the file,
the ADABAS levels, the lengths, ADABAS names, the data types, and the first-last
character positions.
-
VIEW
-
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.
-
column-identifier
-
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 quotes.
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;
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
