CHANGE

C[HANGE] Delimiter OldString Delimiter NewString Delimiter [@]

DO

DO [ CommandNumber CommandString] ]

EDIT

ED[IT] FileName

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] ! } [HP-UXCommand]

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