Most applications use a program structure similar to the following pseudocode to perform a bulk-copy-out operation:
ct_con_props to set connection properties
ct_connect to open the connection
blk_alloc to allocate a CS_BLKDESC
blk_init to initiate the bulk copy
for each column of interest
(optional: blk_describe to get a description of
the column)
blk_bind to either bind the column to a program
variable or to indicate that blk_textxfer will
be used to transfer data for the column.
endfor
while there’s data to transfer
call blk_rowxfer_mult to transfer the row data
pull data from program variables to a permanent
location, if desired.
if data is being transferred via blk_textxfer
for each column to transfer
while there’s data for this column
blk_textxfer to tranfer a chunk of data
endwhile
endfor
endif
endwhile
blk_done(CS_BLK_ALL)
blk_drop to deallocate the CS_BLKDESC