The LIST statement lists the columns in the descriptor along with information about
the columns. The LIST statement can be used when creating an
access descriptor or a
view descriptor. The LIST information is written to your SAS log.
You can specify LIST
as many times as you want while creating a descriptor; specify LIST
last in your PROC ACCESS code to see the completed descriptor information.
Or, if you are creating multiple descriptors, specify LIST before
the next CREATE statement to list all the information about the descriptor
that you are creating.
The LIST statement can
take one of the following arguments:
ALL
lists all the
DBMS columns in the file, the positional equivalents, the SAS
column names, and the SAS formats that are available for the access descriptor. 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.
VIEW
lists all the DBMS columns that are selected for the view descriptor, along with their
positional equivalents, their SAS column names and formats, any subsetting clauses,
and the word *SELECTED*. Any columns that were dropped in the access descriptor are not displayed. The VIEW
argument is valid only for a view descriptor.
column-identifier
lists the specified DBMS column name, its positional equivalent, its SAS column name
and format, 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 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 information
about the fifth and
eighth columns in the descriptor, submit the following statement:
list 5 8;