HP 3000 Manuals HP 3000 Manuals
Chapter 2 ISQL Syntax Summary
Invocation
: RUN ISQL.PUB.SYS
ISQL Filenames
--------------------------------------------------------------------------------------------
| | |
| File Type | Required Filename |
| | |
--------------------------------------------------------------------------------------------
| | |
| Profile File | ISQLPRO (or use a file equation) |
| | |
| Synonym File | ISQLSYN (or use a file equation) |
| | |
| ALLBASE/SQL Message | Default is SQLCT000.PUB.SYS. For native language data, it is |
| Catalog | SQLCTxxx.PUB.SYS, where xxx is a number representing the |
| | current language. |
| | |
| Banner File | Default is SQLWL000.PUB.SYS. For native language data, it is |
| | SQLCTxxx, where xxx is a number representing the current |
| | language. |
| | |
--------------------------------------------------------------------------------------------
ISQL Commands
ISQL Command Summary
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| CHANGE | Modifies the first occurrence or all occurrences of a string in |
| | the command buffer.[REV BEG] |
| | |
| DO | Executes a command in the command history buffer.[REV END] |
| | |
| EDIT | Invokes the editor named in the SET EDITOR option for creating |
| | or updating a file. |
| | |
| END | Terminates an ISQL session and returns you to MPE XL. |
| | |
| ERASE | Deletes a file. |
| | |
| EXIT | Terminates an ISQL session and returns you to MPE XL. |
| | |
| HELP | Displays information about ISQL or SQL commands. |
| | |
| HOLD | Puts SQL and ISQL commands into the command buffer, overwriting |
| | the current contents of the command buffer. |
| | |
| INFO | Displays definitions of the columns of a table or view. |
| | |
| INPUT | Inserts rows into an existing table. |
| | |
| INSTALL | Stores a module contained in an ALLBASE/SQL |
| | preprocessor-generated file into a DBEnvironment. |
| | |
| LIST FILE | Displays the contents of a currently accessible file. |
| | |
| LIST HISTORY | Displays one or all commands in the command history buffer. |
| | |
| LIST INSTALL | Displays the name of a module in an installable module file. |
| | |
| LIST SET | Displays all or any of the current SET option values. |
| | |
| LOAD | Inserts rows into a table from a file. |
| | |
| RECALL | Displays the current contents of the command buffer (up to 2048 |
| | bytes). Optionally, it places a command from the command |
| | history buffer or the contents of a file into the command buffer |
| | and displays it. |
| | |
| REDO | Lets you edit any of the commands in the command history buffer |
| | and optionally execute the edited command. |
| | |
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| RENAME | Changes the name of a file. |
| | |
| SELECT- STATEMENT | Displays the query result when you submit the SQL SELECT |
| | statement through ISQL. |
| | |
| SET | Defines several ISQL environment options. |
| | |
| SQLGEN | Invokes SQLGEN. |
| | |
| SQLUTIL | Invokes SQLUtil. |
| | |
| START | Executes one or more SQL or ISQL commands from the command |
| | buffer or a command file. |
| | |
| STORE | Saves the contents of the command buffer in a command file. |
| | |
| SYSTEM | Lets you execute MPE XL commands from within ISQL. |
| | |
| UNLOAD | Copies data from one or more tables into an output file. |
| | |
--------------------------------------------------------------------------------------------
CHANGE
C[HANGE] Delimiter OldString Delimiter NewString Delimiter [@]
[REV BEG]
DO
DO [CommandNumber]
[CommandString]
[REV END]
EDIT
ED[IT]
END
EN[D]
ERASE
ER[ASE] FileName
EXIT
EX[IT]
HELP
{@ }
HE[LP]{SQLStatement}
{ISQLCommand }
HOLD
HO[LD] {SQLStatement} [EscapeCharacter;{SQLStatement}] [...]
{ISQLCommand } [ {ISQLCommand }]
INFO
IN[FO] {[Owner.]TableName}
{[Owner.]ViewName }
INPUT
INP[UT] {[Owner.]TableName} (ColumnName [,ColumnName] [...] )
{[Owner.]ViewName }
{(Value [,Value] [...] ) [ROLLBACK WORK]} [...] E[ND]
{ [COMMIT WORK ]}
INSTALL
IN[STALL] FileName [DROP]
LIST FILE
LI[ST]F[ILE] FileName
LIST HISTORY
LI[ST] H[ISTORY] {CommandNumber}
{@ }
LIST INSTALL
LI[ST] I[NSTALL] FileName
LIST SET
LI[ST] S[ET] {Option}
{@ }
LOAD
LO[AD] [P[ARTIAL]] FROM {E[XTERNAL]} InputFileName [AT StartingRow]
{I[NTERNAL]}
[FOR NumberOfRows] TO {[Owner.]TableName} [ExternalInputSpec ]
{[Owner.]ViewName } [USING DescriptionFileName]
{Y[ES] PatternLocation Pattern}
{N[O] }
ExternalInputSpec. [REV BEG]
{ColumnName StartingLocation Length [NullIndicator]}[...] E[ND]
{[FormatType] }
[REV END]
RECALL
{C[URRENT] }
REC[ALL] {F[ILE] FileName }
{H[ISTORY] CommandNumber}
REDO
[REV BEG]
RED[O] [CommandNumber]
[CommandString]
[REV END]
Subcommands.
B Break
D Delete
E Exit
H Help
I Insert
L List
R Replace
X Execute
+[n] Forward n
-[n] Backward n
Return Next Line
RENAME
REN[AME] OldFileName NewFileName
SELECTSTATEMENT
SelectStatement;[PA[USE];] [BrowseOption;] [...] E[ND]
SET
SE[T] Option OptionValue
Options and Values. [REV BEG]
AUTOC[OMMIT] ON | OFF
AUTOS[AVE] ON | OFF
C[ONTINUE] ON | OFF
CONV[ERT] ASCII | EBCDIC | OFF
EC[HO] ON | OFF
ECHO_[ALL] ON | OFF
EDITOR EditorName
ES[CAPE] Character
EXIT[_ON_DBERR] ON | OFF
F[RACTION] Length
N[ULL] [Character]
OU[TPUT] FileName
OW[NER] OwnerName
PA[GEWIDTH] PageWidth
PR[OMPT] PromptString[REV END]
SQLGEN
SQLG[EN]
SQLUTIL
SQLU[TIL]
START
STA[RT] [CommandFileName] [(Value [,Value] [...] )]
STORE
STO[RE] FileName [R[EPLACE]]
SYSTEM
{SY[STEM]} [MPE XLCommand]
{: }
UNLOAD
{[Owner.]TableName}
U[NLOAD] TO {E[XTERNAL]} OutputFileName FROM {[Owner.]ViewName }
{I[NTERNAL]} {"SelectCommand" }
ExternalOutputSpec
ExternalOutputSpec.
DescriptionFileName {OutputLength [FractionLength]} [...]
{[NullIndicator] }