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.