ACCESS Procedure Reference

LISTINFO Statement

Shows additional data field information.

Optional statement
Applies to:	access descriptor or view descriptor
Default:	ALL

Syntax
Details

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 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:

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 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;

Top of Page