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     NATIVE-3000    YES

OWNER          Char      (   20)     NO     NATIVE-3000    YES

DBEFISET       Char      (   20)     NO     NATIVE-3000    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     NATIVE-3000    YES

USTIME         Char      (   16)     NO     NATIVE-3000    YES

LANGUAGEID     SmallInt              NO

PARTITION      Char      (   20)     NO     NATIVE-3000    YES



   isql=>