ISQL is the interactive interface to ALLBASE/SQL. Some, but not all, ALLBASE/SQL statements can be entered interactively as ISQL commands.
C[HANGE]Delimiter OldString Delimiter NewString Delimiter [@]
DO [CommandNumber CommandString]
ED[IT][FileName]
EN[D]
ER[ASE]FileName
EX[IT]
EXTRACT{ MODULE[Owner.]ModuleName[,...] SECTION [Owner.]ModuleName(SectionNumber) [,...] ALL MODULES } [NO SETOPTINFO]INTO FileName
HE[LP]{@ SQLStatement ISQLCommand} [D[ESCRIPTION] S[YNTAX] E[XAMPLE] ]
HO[LD]{SQLStatement ISQLCommand}[EscapeCharacter;{SQLStatement ISQLCommand}][...]
IN[FO]{[Owner.]TableName [Owner.]ViewName}
INP[UT]{[Owner.]TableName [Owner.]ViewName} (ColumnName[,ColumnName][...]) { (Value[,Value][...])[ROLLBACK WORK COMMIT WORK] } [...] E[ND]
IN[STALL]FileName[DROP][IN DBEFileSetName][NO OPTINFO]
LI[ST]F[ILE]FileName
LI[ST]H[ISTORY]{CommandNumber @ }
LI[ST[I[NSTALL]FileName
LI[ST]S[ET]{Option @ }
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]
REC[ALL]{C[URRENT] F[ILE]FileName H[ISTORY] CommandNumber}
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
REN[AME]OldFileName NewFileName
SelectStatement;[PA[USE];][BrowseOption;][...]E[ND]
SE[T]Option OptionValue
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
SQLG[EN]
SQLU[TIL]
STA[RT][CommandFileName][ (Value[,Value][...] ) ]
STO[RE] FileName [R[EPLACE] ]
{S[YSTEM] ! }[HP-UXCommand]
U[NLOAD] TO { E[XTERNAL] I[NTERNAL]}OutputFileName FROM {[Owner.]TableName [Owner.]ViewName "SelectCommand"}ExternalOutputSpec
DescriptionFileName{ OutputLength [FractionLength] [NullIndicator] }[...]