SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-64
INVOKE Directive
DATEFORMAT {DEFAULT | EUROPEAN | USA}
specifies the format of host variables for datetime columns.
For a column with a datetime data type that has an HOUR field, DATEFORMAT
USA causes INVOKE to produce a host variable that is three bytes longer than an
equivalent host variable for EUROPEAN or DEFAULT format. The extra bytes allow
room for “am” or “pm” following the values.
The default is DATEFORMAT DEFAULT.
PREFIX indicator-prefix or SUFFIX indicator-suffix
specifies a prefix, a suffix, or both for indicator variable names, in the form:
indicator-prefix variable-name indicator-suffix
The variable-name is the name of the column. If you do not specify a prefix,
indicator variable names have no prefix. If you specify a prefix but do not specify a
suffix, indicator names have no suffix. If you do not specify either a prefix or a
suffix, the suffix depends on the language, as follows:
C _i
COBOL -I
A prefix or suffix must consist of legal identifier values for the host language in
which it is used. However, you can use uppercase or lowercase letters in a prefix
or suffix, regardless of the host language. For C, INVOKE makes the suffix
lowercase.
If the indicator variable name with suffix is longer than 31 characters, the name is
truncated to 31 characters. A warning is issued for each truncated name.
NULL STRUCTURE
specifies that a column allowing null should be declared as a structure with the
same name as the column and with fields for the data item and its indicator
variable. The fields are named INDICATOR and VALU.
CHAR AS {STRING | ARRAY}
(for C programs) specifies whether to create a byte for the null terminator in C
character types:
The default is CHAR AS STRING.
For more information about creating C and COBOL host variables using INVOKE, see
the SQL/MX Programming Manual for C and COBOL.
STRING Generate the extra byte.
ARRAY Omit the extra byte.