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] INTOFileName

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 StartingLocationLength [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