HP 3000 Manuals HP 3000 Manuals
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
Column Name Data Type (length) Nulls Allowed Language
---------------------------------------------------------------------
ColumnName Type (length) YES or NO LanguageName
:
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;
Column Name Data Type (length) Nulls Allowed Language
---------------------------------------------------------------------
NAME Char ( 20) NO NATIVE-3000
OWNER Char ( 20) NO NATIVE-3000
DBEFILESET Char ( 20) NO NATIVE-3000
TYPE SmallInt NO
RTYPE SmallInt NO
NUMC Integer NO
NUMI Integer NO
NPAGES Integer NO
NROWS Integer NO
AVGLEN Integer NO
CTIME Char ( 16) NO NATIVE-3000
USTIME Char ( 16) NO NATIVE-3000
LANGUAGEID Integer NO
isql=>