SQL Programming Manual for Pascal

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for Pascal—528614-001
3-35
SQL
Instead, the statement should be worded like this:
EXEC SQL SELECT A INTO :NAME FROM T
WHERE A > :NAME2 EXCLUSIVE MODE;
SQL
The SQL directive causes the Pascal compiler to process SQL statements and
directives. The SQL directive must appear as the first line of the primary source file or
in the command line when you run the Pascal compiler.
RELEASE1 | RELEASE2
specifies the NonStop SQL release version that supports the program. This release
option affects the version of the SQLDA structures generated for the application
and internally marks the object program as RELEASE1 or RELEASE2. Static SQL
structures generate internal SQLDA structures used by SQL components.
RELEASE1
specifies code and SQLDA structures acceptable to the C10 release of the
SQL compiler. Use this option to develop NonStop SQL applications on a C30
system that can be SQL compiled and run either on C10 or C30 systems. The
generated internal SQLDA structure, however, does not support null values or
new C30 SQL data types: FLOAT, DOUBLE PRECISION, REAL, DATETIME,
DATE, TIME, TIMESTAMP, and INTERVAL. If the program attempts to retrieve
columns of these types, NonStop SQL reports an error.
If you SQL compile the program with a C10 SQL compiler, SQL will reject
RELEASE2 features. For detailed information on RELEASE2 features and
using the release version options, see Appendix D, NonStop SQL Version
Issues.
RELEASE2
specifies code and SQLDA structures acceptable to a C30 SQL compiler. A
RELEASE2 program cannot be SQL compiled or run on a C10 system.
The default is RELEASE2.
?SQL [ option ]
[ ( option [ , option ] ... ) ]
option is:
[ RELEASE1 | RELEASE2 ]
[ SQLMAP | NOSQLMAP ]
[ WHENEVERLIST | NOWHENEVERLIST ]