The DB-Library routine dbcursorbind binds a cursor result column to an array of program variables. The array has a number of rows equal to the size of the fetch buffer specified in the application’s call to dbcursoropen.
The Client-Library routine ct_bind can bind a cursor result column either to a single program variable or to an array of program variables. The value of datafmt→count determines the size of the array.
For both DB-Library and Client-Library, the size of the array must be the same for all columns in the result set.
The following considerations apply when using array binding with updatable Client-Library cursors:
Before the Client-Library cursor is opened, the application must call ct_cmd_props to allow the CS_HIDDEN_KEYS property.
Updates to intermediate rows in the result array must be preceded by calls to ct_keydata to position the update with the key values for the intermediate row. If the update is not positioned in this way, it will affect the last row fetched instead of the intermediate row.