Sets the program variable data length for the current bulk copy into Microsoft® SQL Server™ 2000.
RETCODE bcp_collen (
INT table_column );
Is the DBPROCESS structure that is the handle for a particular workstation or SQL Server process. It contains all the information that DB-Library uses to manage communications and data between the workstation and SQL Server.
Is the length of the program variable, which does not include the length of the length prefix or terminator. Setting varlen to 0 signifies that the data is NULL. Setting it to -1 signifies that the data is variable length and that the length is determined by the length prefix or terminator. If both a length prefix and a terminator exist, bcp uses the one that results in the shortest amount of data being copied.
Is the column in the SQL Server table to which the data is copied. Column numbers start at 1.
SUCCEED or FAIL.
The bcp_collen function allows you to change the program variable data length for a particular column while running a copy in through calls to bcp_bind.
Initially, the program variable data length is determined when bcp_bind is called. If the program variable data length changes between calls to bcp_sendrow and no length prefix or terminator is being used, you can call bcp_collen to reset the length. The next call to bcp_sendrow uses the length you just set.
There must be a separate bcp_collen call for every column in the table whose data length you want to modify.