Chapter Contents |
Previous |
Next |
LISTINFO |
Optional statement | |
Applies to: | access descriptor or view descriptor |
Default: | ALL |
Syntax | |
Details |
Syntax |
LISTINFO <ALL | VIEW | column-identifier-1 <... column-identifier-n>>; |
Details |
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:
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;
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.