SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
T-3
TEDIT Command
The columns TABLENAME through SECURITYVECTOR (1 through 9) were created in
version 1. The columns SECURITYMODE through OBJECTVERSION (10 through 11)
were added in version 300. Column SIMILARITYCHECK (12) was added at version
310.
Guardian names in the TABLES table are fully qualified and use uppercase characters.
TEDIT Command
TEDIT is an SQLCI command that invokes the PS Text Edit editor.
tedit-command-line
is one or more TEDIT commands, as described in the PS Text Edit Reference
Manual.
If you specify more than one command, you must use a semicolon between
commands and enclose tedit-command-line in quotation marks, as shown:
TEDIT "QUERY6; LASTPAGE";
Example—TEDIT
This example invokes TEDIT from SQLCI:
>> TEDIT;
10 SECURITYMODE CHAR(1) S if Safeguard security
G if Guardian security
11 OBJECTVERSION SMALLINT
UNSIGNED
Version of table, view, or collation
12 SIMILARITYCHECK VARCHAR(3
0)
ENABLED if similarity check is allowed,
DISABLED if not
* Indicates primary key
TEDIT [tedit-command-line] ;
Table T-1. The TABLES Table (page 2 of 2)
Column Name Data Type Description