Transmitting binary data

When an RSP uses a DB2 format data pipe, EBCDIC-ASCII or ASCII-EBCDIC conversion does not occur for the columns defined as binary. When you use DB2 format data, each binary column is indicated by setting the corresponding SQLDATA field to X'0000FFFF' at OPENPIPE. You can define only CHAR, VARCHAR, and LVARCHAR columns as binary.

The RSP must set the SQLDATA field appropriately. To indicate whether a column contains binary or normal data, you place the appropriate value in the corresponding SQLDATA field before issuing the OPENPIPE command:

X'xxxxxxxx' (for normal data)
 X'0000FFFF' (for binary data)

where:

If any columns were defined as binary, the corresponding SQLDATA fields must be reset to point to the actual column data after the OPENPIPE is issued.

See Appendix G, “The SQLDA” for more information on the SQLDA.