Using binary items in SQLIMS statements
For binary data items that you specify in an EXEC
SQLIMS statement, you can define the
data items as either USAGE COMP-5 or as USAGE
BINARY, COMP, or COMP-4.
About this task
If you define the
binary data items as USAGE BINARY, COMP,
or COMP-4, use the TRUNC(BIN) compiler
option. Using this option might have a larger effect on performance
than using USAGE COMP-5 on individual data items.
If instead you use the TRUNC(OPT) or TRUNC(STD) compiler
options, the compiler accepts the items but the data might not be
valid because of the decimal truncation rules. You must ensure that
truncation does not affect the validity of the data.