![](../../img/s.gif) |
» |
|
|
|
ISQL is the interactive interface to ALLBASE/SQL. Some, but not all, ALLBASE/SQL statements can be entered interactively as ISQL commands. CHANGE | ![](../../img/s.gif) |
C[HANGE] Delimiter OldString Delimiter NewString Delimiter [@] DO | ![](../../img/s.gif) |
DO [CommandNumber
CommandString] EDIT | ![](../../img/s.gif) |
END | ![](../../img/s.gif) |
ERASE | ![](../../img/s.gif) |
EXIT | ![](../../img/s.gif) |
EXTRACT | ![](../../img/s.gif) |
EXTRACT { MODULE [Owner.]ModuleName [,...] SECTION [Owner.]ModuleName(SectionNumber) [,...] ALL MODULES } [NO SETOPTINFO] INTO FileName HELP | ![](../../img/s.gif) |
HE[LP] { @ SQLStatement ISQLCommand } [ D[ESCRIPTION] S[YNTAX] E[AMPLE] ] HOLD | ![](../../img/s.gif) |
HO[LD] { SQLStatement ISQLCommand } [EscapeCharacter; { SQLStatement ISQLCommand }
] [...] INFO | ![](../../img/s.gif) |
IN[FO] { [Owner.]
TableName [Owner.]ViewName } INPUT | ![](../../img/s.gif) |
INP[UT] { [Owner.]TableName [Owner.]ViewName } (ColumnName [,ColumnName] [...] ) { (Value [,Value] [...] ) [ ROLLBACK WORK COMMIT WORK ]} [...]
E[ND] INSTALL | ![](../../img/s.gif) |
IN[STALL] FileName [DROP] [IN DBEFileSetName] [NO OPTINFO] LIST FILE | ![](../../img/s.gif) |
LIST HISTORY | ![](../../img/s.gif) |
LI[ST] H[ISTORY] { CommandNumber @ } LIST INSTALL | ![](../../img/s.gif) |
LI[ST] I[NSTALL] FileName LIST SET | ![](../../img/s.gif) |
LI[ST] S[ET] { Option @ } LOAD | ![](../../img/s.gif) |
LO[AD] [P[ARTIAL]] FROM { E[XTERNAL] I[NTERNAL] } InputFileName
[AT StartingRow]
[FOR NumberOfRows] TO { [Owner.]TableName [Owner.]ViewName }
[ ExternalInputSpec USING DescriptionFileName ]
{ Y[ES] PatternLocation Pattern N[O] } { ColumnName StartingLocation Length [NullIndicator] [FormatType]} [...] E[ND] RECALL | ![](../../img/s.gif) |
REC[ALL] { C[URRENT] F[ILE] FileName H[ISTORY] CommandNumber } REDO | ![](../../img/s.gif) |
RED[O] [ CommandNumber CommandString ]
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 | ![](../../img/s.gif) |
REN[AME] OldFileName NewFileName SELECTSTATEMENT | ![](../../img/s.gif) |
SelectStatement; [PA[USE];] [BrowseOption;] [...] E [ND] SET | ![](../../img/s.gif) |
AUTOC[OMMIT] ON | OFF
AUTOL[OCK] ON | OFF
AUTOS[AVE] NumberofRows
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
EXIT_ON_DBWARN ON | OFF
FL[AGGER] FlaggerName
F[RACTION] Length
N[ULL] [Character]
OU[TPUT] FileName
OW[NER] OwnerName
LOAD_B[UFFER] BufferSize
PA[GEWIDTH] PageWidth
PR[OMPT] PromptString
|
SQLGEN | ![](../../img/s.gif) |
SQLUTIL | ![](../../img/s.gif) |
START | ![](../../img/s.gif) |
STA[RT] [CommandFileName] [ (Value [,Value] [...] )] STORE | ![](../../img/s.gif) |
STO[RE] FileName [R[EPLACE]] SYSTEM | ![](../../img/s.gif) |
{ SY[STEM] : } [MPE/iXCommand] UNLOAD | ![](../../img/s.gif) |
U[NLOAD] TO { E[XTERNAL] I[NTERNAL] } OutputFileName FROM { [Owner.]TableName [Owner.]ViewName "SelectCommand" } ExternalOutputSpec DescriptionFileName { OutputLength [FractionLength] [NullIndicator]} [...]
|