To ensure that you specify the length of character string
parameters correctly, use the following guidelines:
o For C host language programs that call SQL modules declared
with LANGUAGE C, any character parameters that correspond
to character data type columns must be defined as the length
of the longest valid column value in octets, plus 1 octet to
allow for the null terminator.
o For other host language programs (or C host language programs
that call SQL modules declared with LANGUAGE GENERAL), any
character parameters that correspond to character data type
columns must be defined as the length of the longest valid
column value in octets.
o When calculating the length of the longest valid column value,
you must take into consideration the number of octets for
each character in the character set of the column and whether
the SQL module language interprets the length of columns in
characters or octets. A program can control how the SQL module
language interprets the length of columns in the following
ways:
- The CHARACTER LENGTH clause of the module header or DECLARE
MODULE statement
- The DIALECT clause of the module header or DECLARE MODULE
statement
- For dynamic SQL, the SET CHARACTER LENGTH statement