NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-60
SQL Directive
•
The following 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 NonStop 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.
See Reserved Words
on page R-13 for a list of reserved SQL keywords.
All of the following are valid SQL identifiers:
•
ColumName
•
MONTH3ORDERS
•
second_low_value
•
EMPLOYEE
•
ORD_DATE
•
THE_END_