Ap D. ISQL Syntax Summary [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
Appendix D ISQL Syntax Summary
[REV BEG]
ISQL is the interactive interface to ALLBASE/SQL. Some, but not all,
ALLBASE/SQL statements can be entered interactively as ISQL commands.[REV
END]
CHANGE
C[HANGE] Delimiter OldString Delimiter NewString Delimiter [@]
DO
DO [CommandNumber]
[CommandString]
EDIT
ED[IT]
END
EN[D]
ERASE
ER[ASE] FileName
EXIT
EX[IT]
EXTRACT
{MODULE [Owner.]ModuleName [,...] }
EXTRACT {SECTION [Owner.]ModuleName(SectionNumber) [,...]}
{ALL MODULES }
[NO SETOPTINFO] INTO FileName
HELP
{@ } [D[ESCRIPTION]]
HE[LP]{SQLStatement} [S[YNTAX] ]
{ISQLCommand } [E[AMPLE] ]
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] [IN DBEFileSetName] [NO OPTINFO]
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.
{ColumnName StartingLocation Length [NullIndicator]}[...] E[ND]
{[FormatType] }
RECALL
{C[URRENT] }
REC[ALL] {F[ILE] FileName }
{H[ISTORY] CommandNumber}
REDO
RED[O] [CommandNumber]
[CommandString]
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.
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
SQLG[EN]
SQLUTIL
SQLU[TIL]
START
STA[RT] [CommandFileName] [(Value [,Value] [...] )]
STORE
STO[RE] FileName [R[EPLACE]]
SYSTEM
{SY[STEM]} [MPE/iXCommand]
{: }
UNLOAD
{[Owner.]TableName}
U[NLOAD] TO {E[XTERNAL]} OutputFileName FROM {[Owner.]ViewName }
{I[NTERNAL]} {"SelectCommand" }
ExternalOutputSpec
ExternalOutputSpec.
DescriptionFileName {OutputLength [FractionLength]} [...]
{[NullIndicator] }
MPE/iX 5.5 Documentation