ISQL is the interactive interface to ALLBASE/SQL. Some, but not all, ALLBASE/SQL statements can be entered interactively as ISQL commands.

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

EXTRACT { MODULE [Owner.]ModuleName [,...] SECTION [Owner.]ModuleName(SectionNumber) [,...] ALL MODULES } [NO SETOPTINFO] INTO FileName

HELP

HE[LP] { @ SQLStatement ISQLCommand } [ D[ESCRIPTION] S[YNTAX] E[AMPLE] ]

HOLD

HO[LD] { SQLStatement ISQLCommand } [EscapeCharacter; { SQLStatement ISQLCommand } ] [...]

INFO

IN[FO] { [Owner.] TableName [Owner.]ViewName }

INPUT

INP[UT] { [Owner.]TableName [Owner.]ViewName } (ColumnName [,ColumnName] [...] ) { (Value [,Value] [...] ) [ ROLLBACK WORK COMMIT WORK ]} [...] E[ND]

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] I[NTERNAL] } InputFileName [AT StartingRow] [FOR NumberOfRows] TO { [Owner.]TableName [Owner.]ViewName } [ ExternalInputSpec USING DescriptionFileName ] { Y[ES] PatternLocation Pattern N[O] }

ExternalInputSpec

{ ColumnName StartingLocation Length [NullIndicator] [FormatType]} [...] E[ND]

RECALL

REC[ALL] { C[URRENT] 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

U[NLOAD] TO { E[XTERNAL] I[NTERNAL] } OutputFileName FROM { [Owner.]TableName [Owner.]ViewName "SelectCommand" } ExternalOutputSpec

ExternalOutputSpec

DescriptionFileName { OutputLength [FractionLength] [NullIndicator]} [...]

Technical documentation

» Table of Contents

» Index