HP 3000 Manuals HP 3000 Manuals
Chapter 6 SQLGEN Syntax Summary
Invocation From Inside ISQL
isql=> sqlgen;
Invocation From Outside ISQL
: RUN SQLGEN.PUB.SYS
SQLGEN Commands
SQLGEN Command Summary
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| EDITOR | Invokes the current editor. |
| | |
| EXIT | Terminates SQLGEN execution. |
| | |
| GENERATE ALL | Generates statements for entire DBEnvironment. |
| | |
| GENERATE DBE | Generates the START DBE NEW command. |
| | |
| GENERATE DBEFILES | Generates statements to recreate DBEFileSets. |
| | |
| GENERATE GROUPS | Generates statements to recreate all groups. |
| | |
| GENERATE INDEXES | Generates statements to recreate indexes. |
| | |
--------------------------------------------------------------------------------------------
Table 6-0. SQLGEN Command Summary (cont.)
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| GENERATE LOAD | Generates statements to UNLOAD and LOAD tables. |
| | |
| GENERATE MODAUTH | Generates statements to define module authority.[REV BEG] |
| | |
| GENERATE PROCAUTH | Generates statements to recreate authorities for procedures. |
| | |
| GENERATE PROCEDURES | Generates statements to recreate procedures. |
| | |
| GENERATE RULES | Generates statements to recreate rules.[REV END] |
| | |
| GENERATE SPECAUTH | Generates statements to define special authority. |
| | |
| GENERATE STATISTICS | Generates statements to UPDATE STATISTICS on tables. |
| | |
| GENERATE TABAUTH | Generates statements to define table authority. |
| | |
| GENERATE TABLES | Generates statements to recreate tables.[REV BEG] |
| | |
| GENERATE TEMPSPACES | Generates statements to recreate tempspaces.[REV END] |
| | |
| GENERATE VIEWAUTH | Generates statements to define view authority.[REV BEG] |
| | |
| GENERATE VIEW | Generates statements to recreate views.[REV END] |
| | |
| HELP | Displays and describes all SQLGEN commands. |
| | |
| RELEASE | Terminates the DBE session.[REV BEG] |
| | |
| SET ECHO_ALL | Echoes batch user input to the standard list.[REV END] |
| | |
--------------------------------------------------------------------------------------------
Table 6-0. SQLGEN Command Summary (cont.)
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| SET EDITOR | Defines the current editor.[REV BEG] |
| | |
| SET EXIT_ON_DBERR | Terminates immediately when an SQL error is encountered.[REV |
| | END] |
| | |
| SET SCHEMA | Defines the schema file name for output. |
| | |
| STARTDBE | Starts DBE session for SQLGEN execution. |
| | |
| : | Escapes temporarily to the operating system for the execution of |
| | operating system commands. |
| | |
--------------------------------------------------------------------------------------------
EDITOR
>> ED[ITOR]
EXIT
>> E[XIT]
GENERATE ALL
>> [GEN[ERATE]]ALL Schema file Name or '//' to STOP command >>
SchemaFileName
GENERATE DBE
>> [GEN[ERATE]] DBE Schema File Name or '//' to STOP command >>
SchemaFileName
GENERATE DBEFILES
>> [GEN[ERATE]] DBEFILE[S] Schema File Name or '//' to STOP command >>
SchemaFileName DBEFileSet Name >> DBEFileSetName
GENERATE GROUPS
>> [GEN[ERATE]]GROUP[S] Schema File Name or '//' to STOP command >>
SchemaFileName
GENERATE INDEXES
>> [GEN[ERATE]]INDEX[ES] Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Table
Names for each Owner (n/y)? {N[O] } Table Name for Owner OwnerName >>
{Y[ES]}
TableName
GENERATE LOAD
>> [GEN[ERATE]] LOAD Unload Schema File Name or '//' to STOP command >>
UnloadFile Load Schema File Name or '//' to STOP command >> LoadFile
Prefix for Unloaded Data File Names >> UNLDPrefix UPDATE STATISTICS
after Loading (n/y)? {N[O] } Internal or External Format (Int/Ext) >>
{Y[ES]}
{INT[ERNAL]} NULL Indicator (?) >> NullIndicator Prefix for
{EXT[ERNAL]}
DESCRIPTION File Names >> DESCPrefix Owner Name >> OwnerName Do you
wish to specify Table Names for each Owner (n/y)? {N[O] } Table Name
{Y[ES]}
for Owner OwnerName >> TableName
GENERATE MODAUTH
>> [GEN[ERATE]] MODAUTH Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName
GENERATE PROCAUTH
>> [GEN[ERATE]] PROCAUTH Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Procedure
Names for each Owner (n/y)? {N[O] } Procedure Name for Owner OwnerName
{Y[ES]}
>> ProcedureName
GENERATE PROCEDURES
>> [GEN[ERATE]] PROCEDURE[S] Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Procedure
Names for each Owner (n/y)? {N[O] } Procedure Name for Owner OwnerName
{Y[ES]}
>> ProcedureName
GENERATE RULES
>> [GEN[ERATE]] RULE[S] Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Rule
Names for each Owner (n/y)? {N[O] } Rule Name for Owner OwnerName >>
{Y[ES]}
RuleName
GENERATE SPECAUTH
>> [GEN[ERATE]] SPECAUTH Schema File Name or '//' to STOP command >>
SchemaFileName
GENERATE STATISTICS
>> [GEN[ERATE]] STAT[ISTICS] Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Table
Names for each Owner (n/y)? {N[O] } Table Name for Owner OwnerName >>
{Y[ES]}
TableName
GENERATE TABAUTH
>> [GEN[ERATE]] TABAUTH Schema File Name or '//'to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify Table
Names for each Owner (n/y)? {N[O] } Table Name for Owner OwnerName >>
{Y[ES]}
TableName
GENERATE TABLES
>> [GEN[ERATE]] TABLE[S] Schema File Name or '//' to STOP command >>
SchemaFileName Do you wish to generate associated Indexes (n/y)?
{N[O] } Do you wish to generate associated Table Authority (n/y)?
{Y[ES]}
{N[O] } Owner Name >> OwnerName Do you wish to specify Table Names for
{Y[ES]}
each Owner (n/y)? {N[O] } Table Name >> TableName
{Y[ES]}
GENERATE TEMPSPACES
>> [GEN[ERATE]] TEMPSPACE[S] Schema File Name or '//' to STOP command >>
SchemaFileName TEMPSPACE Name >> TempSpaceName
GENERATE VIEWAUTH
>> [GEN[ERATE]] VIEWAUTH Schema File Name or '//' to STOP command >>
SchemaFileName Owner Name >> OwnerName Do you wish to specify View
Names for each Owner (n/y)? {N[O] } View Name for Owner OwnerName >>
{Y[ES]}
ViewName
GENERATE VIEWS
>> [GEN[ERATE]] VIEW[S] Schema File Name or '//' to STOP command >>
SchemaFileName Do you wish to generate associated View Authority (n/y)?
{N[O] } Owner Name >> OwnerName Do you wish to specify View Names for
{Y[ES]}
each Owner (n/y)? {N[O] } View Name for Owner OwnerName >> ViewName
{Y[ES]}
HELP
>> H[ELP] {CommandName}
{Keyword }
RELEASE
>>RELEASE
SET ECHO_ALL OFF
>> SET ECHO_ALL OFF
SET ECHO_ALL ON
>> SET ECHO_ALL ON
SET EDITOR
>> SE[T] ED[ITOR]
SET EXIT_ON_DBERR OFF
>> SET EXIT_ON_DBERR OFF
SET EXIT_ON_DBERR ON
>> SET EXIT_ON_DBERR ON
SET SCHEMA
>> SE[T] SCH[EMA] Schema File Name or '//' to STOP command >>
SchemaFileName
STARTDBE
>> START[DBE] [DBEnvironmentName]
:
>> : [CommandName];