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.