SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
H-3
Considerations—HELP
The default is SYNTAX.
Considerations—HELP

HELP topics correspond to the main words of each major entry in the SQL/MP
Reference Manual. For example, HELP is available for the topic CREATE TABLE
(not CREATE or CREATE TABLE statement).
In some cases, HELP contains additional “pointer entries” that direct you to
available topics. For example, if you enter HELP CREATE, SQLCI responds by
listing available topics that begin with the word “create”:
Enter: HELP create catalog
create constraint
create collation
create index
create system catalog
create table
create view

If the entire help text for a topic fits on the screen, SQLCI displays the text and
returns you to the standard SQLCI prompt. If the help text is too long for one
screen, SQLCI displays the first part of the text followed by a continuation prompt.
SQLCI displays information at the bottom of each screen of text that tells you what
to press to display more detail or to return to the standard prompt.
Examples—HELP

This command displays the available HELP topics:
HELP ALL;

This commands display information about the CREATE TABLE statement. The
information displayed by the third command includes all the information displayed
by the first two commands:
HELP CREATE TABLE;
HELP CREATE TABLE, EXAMPLE;
HELP CREATE TABLE, DETAIL;