SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-36
SQL
PAGES num-pages
specifies the number of 2048-byte pages of memory available to the TAL compiler
to process SQL statements. The default is 384 pages, which is the minimum
number required and a usable value for most programs.
A recommended upper limit is 32,000. The actual upper limit depends on space
allocated by the compiler and a value specified by the SYMBOLPAGES directive.
By increasing the value, you increase the number of lines allowed in an SQL
statement.
WHENEVERLIST | NOWHENEVERLIST
controls writing active WHENEVER options to the listing file after each SQL
statement is processed.
WHENEVERLIST
specifies writing the options.
NOWHENEVERLIST
WHENEVER options are not written. NOWHENEVERLIST is the default.
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.
RELEASE1
specifies object code and SQLDA structures that are compatible with the
NonStop SQL C10 compiler. If you specify RELEASE1, the program can be
SQL compiled and run on a C10 or C30 system. You can use RELEASE1 to
develop programs on a C30 system that will run on a C10 system.
The SQLDA structure, however, does not support null values or the C30 SQL
data types: FLOAT, DOUBLE PRECISION, REAL, DATETIME, DATE, TIME,
TIMESTAMP, and INTERVAL.
If you compile the program with a NonStop SQL C10 compiler, the SQL
compiler rejects C30 features. For detailed information on RELEASE2 features
and using the release version options, see Appendix D, NonStop SQL Version
Issues.
RELEASE2
specifies object code and SQLDA structures that are compatible with the
NonStop SQL C30 compiler. A program compiled with RELEASE2 cannot be
SQL compiled or run on a NonStop SQL C10 system. RELEASE2 is the
default.