HP 3000 Manuals

ALLBASE/ISQL Reference Manual

Getting Help 

ISQL has a HELP command you can use to obtain information about the
function and syntax of any ISQL or SQL command.  The following example
obtains information about the DELETE statement:

     isql=> HELP DELETE; 

     ======================
       SQL DELETE Command
     ======================

     The DELETE command deletes a row or rows from a table.

     The DELETE WHERE CURRENT command deletes the current row.  The
     current row is the row pointed to by a cursor after the FETCH
     command is issued.

     --- SYNTAX ---

       DELETE FROM {[Owner.]TableName} [WHERE SearchCondition]
           {[Owner.]ViewName }

       DELETE FROM {[Owner.]TableName} [WHERE CURRENT OF CursorName]
           {[Owner.]ViewName }

     --- EXAMPLE ---

       DELETE FROM PurchDB.Orders
         WHERE OrderDate < '19830701'

       DELETE FROM PurchDB.OrderItems
         WHERE CURRENT OF DeleteItemsCursor

     isql=>

When you specify a verb that is used in more than one command, ISQL
displays information about all commands containing the verb.  For
example, HELP START would give you information for the ISQL START command
and the following SQL statements:  START DBE, START DBE NEW, and START
DBE NEWLOG.

MPE/iX 5.0 Documentation