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

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