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