HP 3000 Manuals HP 3000 Manuals
HELP
The HELP command displays information about ISQL or SQL commands.
Scope
ISQL only.
ISQL Syntax
{@ }
HE[LP]{SQLstatement}
{ISQLcommand }
Parameters
@ is specified to obtain a list of the ISQL
commands and a list of the SQL statements.
SQLstatement is any SQL statement verb.
ISQLcommand is any unabbreviated ISQL command verb.
Description
* If you specify a command verb that is used in more than one
command, ISQL displays information about all commands that
qualify. For example, HELP ALTER would display information for
both ALTER DBEFILE and ALTER TABLE.
* In prompting mode, ISQL prompts you for a command name, as shown
below:
isql=> HELP;
Name of command for help> Enter SQLstatement; or ISQLcommand;.
Information is displayed.
Example
isql=> HELP input;
======================
ISQL INPUT Command
======================
The INPUT command inserts rows into an existing table.
--- SYNTAX ---
INP[UT] {[Owner.]TableName } (ColumnName [,ColumnName...])
{[Owner.]ViewName }
(Value [,Value ..]) [ ROLLBACK WORK ]
[ COMMIT WORK ]
[...]
E[ND]
--- EXAMPLE ---
INPUT PurchDB.Parts (PartNumber)
('2033-KLT-01')
('2034-BLT-01')
END;
isql=> HELP @;
Help is available for the following:
[REV BEG]
===== SQL Commands =====
ADD ALTER BEGIN CHECKPOINT CLOSE
COMMIT CONNECT CREATE DECLARE DELETE
DESCRIBE DISCONNECT DROP END EXECUTE
FETCH GRANT INCLUDE INSERT LOCK
OPEN PREPARE REFETCH RELEASE REMOVE
RESET REVOKE ROLLBACK SAVEPOINT SELECT
SQLEXPLAIN START STOP TERMINATE TRANSFER
UPDATE VALIDATE WHENEVER[REV END]
===== ISQL Commands =====
CHANGE EDIT END ERASE EXIT
HELP HOLD INFO INPUT INSTALL
LIST LOAD RECALL REDO RENAME
SET SQLGEN SQLUTIL START STORE
SYSTEM UNLOAD
isql=>