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:

   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.