SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-59
SQL Directive

This example uses the SPACE layout option to change the default number of
spaces between columns. The content of the report (not the spacing) is the same
as in the previous example.
>> SET LAYOUT SPACE 5;
>> SET LIST_COUNT 0;
>> SELECT * FROM PERSNL.JOB;
S> LIST NEXT 4;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
200 PRODUCTION SUPV
250 ASSEMBLER
300 SALESREP
SQL Directive
The SQL directive indicates to a host language compiler that a program contains SQL
statements.
For more information about the SQL directive, see the SQL/MP programming manual
for your host language.
SQL Identifiers
An SQL identifier can contain up to 30 letters (A through Z or a through z), digits (0
through 9), or underscore (_) characters. The first character must be a letter. SQL
ignores case in SQL identifiers; for example, employee and EMPLOYEE are
equivalent.
SQL identifiers are used as column, constraint, correlation, cursor, parameter, and
statement names and cannot be the same as any keyword reserved for SQL
statements. For a list of reserved SQL keywords, see Reserved Words
on page R-11.
Valid SQL identifiers are:

ColumnName

MONTH3ORDERS

second_low_value

EMPLOYEE

ORD_DATE

THE_END_