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[XAMPLE]     ]

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

  {S[YSTEM]
   !        }[HP-UXCommand]

UNLOAD

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

ExternalOutputSpec

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