HP 3000 Manuals

Getting Help [ ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL ] MPE/iX 5.0 Documentation


ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

Getting Help 

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

     isql=> HELP DELETE; 

     SCOPE:  ISQL or Application Programs

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

     ==========
       SYNTAX
     ==========

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

     ===========
       EXAMPLE
     ===========

     DELETE FROM PurchDB.Orders
       WHERE OrderDate < '19830701' ;

     isql=>

When you specify a verb that is used in more than one command, ISQL lists
all the commands that qualify and prompts you to enter the complete
command.  If you do not specify Description, Syntax, or Example in the
command line, all three types of help text are displayed.
[REV END]



MPE/iX 5.0 Documentation