Access a varying-length opaque type

The var binary data type allows you to access the internal format of either of the following opaque data types:
  • A fixed-length opaque-type column for which you do not have access to the C-structure of the internal format
  • A varying-length opaque-type column
Follow these steps to transfer the internal format of either of these opaque data type columns between the database server and the application:
  1. Declare a var binary host variable
  2. Use the var binary host variable in an SQL statement to perform any select, insert, update, or delete operations on the internal format of the opaque-type column.