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