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