SQL/MX 3.2 Programming Manual for C and COBOL (H06.25+, J06.14+)

Host Variables in C/C++ Programs
HP NonStop SQL/MX Release 3.2 Programming Manual for C and COBOL—663854-002
3-40
INVOKE and Date-Time and Interval Host Variables
(SQL/MX Release 1.8 Applications)
INVOKE and Date-Time and Interval Host Variables (SQL/MX
Release 1.8 Applications)
SQL/MX Release 1.8 does not support SQL:1999 date-time host variables. In SQL/MX
Release 1.8 applications, you must declare a character array host variable for date-
time or interval data and use the CAST function for input or output from date-time or
interval columns.
If your SQL/MX Release 1.8 application uses INVOKE to create a date-time or interval
host variable and you plan to preprocess the application in SQL/MX Release 2.x, use
the -e preprocessor option. Otherwise, SQL/MX Release 2.x returns an error during
SQL compilation because the CAST function in the program is incompatible with the
SQL:1999 date-time host variables created by INVOKE in SQL/MX Release 2.x.
For more information, see Running the SQL/MX C/C++ Preprocessor on page 15-8.
Note. This issue affects only SQL/MX Release 1.8 applications preprocessed by SQL/MX
Release 2.x. Previously compiled SQL/MX Release 1.8 applications continue to run correctly
without changes in SQL/MX Release 2.x.