INFO

The INFO command displays definitions of the columns of a table or view.

Scope

ISQL only.

ISQL Syntax

IN[FO] {[Owner.] TableName [Owner.] ViewName }

Parameters

[Owner.] TableName: identifies a table in the DBEnvironment you are using.
[Owner]. ViewName: identifies a view in the DBEnvironment you are using.

Description

ISQL responds with the name of the language of the table and a display of its column definition.
The following information is displayed for each column in the table or view:
- Column name.
- Data type.
- In parentheses, length (in bytes) of CHAR or VARCHAR data, or precision and scale of DECIMAL, REAL, or FLOAT data.
- Indication (YES or NO) of whether null values are allowed.
- Name of the language for each CHAR or VARCHAR column.
You must establish a DBE session before you can use INFO. Use the SQL CONNECT or START DBE statement to establish a DBE session.

In prompting mode, ISQL prompts you for a table name as follows:

   isql=> INFO;



   Table name> TableName;  or    ViewName;

   Table language = LanguageName



                                            Nulls                   Case

   Column Name       Data Type  (length)       Allowed   Language      Sensitive

   -----------------------------------------------------------------------------

   ColumnName      Type   (length)              YES or NO   LangName      YES or NO



   .

   .

   .

   isql=>

Authorization

You must have authorization to select from the named table or view. Refer to the discussion of the SELECT statement in the ALLBASE/SQL Reference Manual.

Example



   isql=> INFO System.Table;



                                            Nulls                   Case

   Column Name       Data Type  (length)       Allowed  Language       Sensitive

   ----------------------------------------------------------------------------

   NAME               Char      (   20)          NO     n-computer       YES

   OWNER              Char      (   20)          NO     n-computer       YES

   DBEFISET           Char      (   20)          NO     n-computer       YES

   TYPE               SmallInt                   NO

   RTYPE              SmallInt                   NO

   NUMC               Integer                    NO

   NUMI               Integer                    NO

   NUMIC              Integer                    NO

   NUMR               Integer                    NO

   NPAGES             Integer                    NO

   NROWS              Integer                    NO

   AVGLEN             Integer                    NO

   CTIME              Char      (   16)          NO     n-computer       YES

   USTIME             Char      (   16)          NO     n-computer       YES

   LANGUAGEID         SmallInt                   NO

   PARTITION          Char      (   20)          NO     n-computer       YES



   isql=>