| title | bcp_colptr | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.technology | native-client | |
| ms.topic | reference | |
| apiname |
|
|
| apilocation |
|
|
| apitype | DLLExport | |
| helpviewer_keywords |
|
|
| ms.assetid | 02ece13e-1da3-4f9d-b860-3177e43d2471 | |
| author | markingmyname | |
| ms.author | maghan | |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
Sets the program variable data address for the current copy into [!INCLUDEssNoVersion].
RETCODE bcp_colptr (
HDBC hdbc,
LPCBYTE pData,
INT idxServerCol);
hdbc
Is the bulk copy-enabled ODBC connection handle.
pData
Is a pointer to the data to copy. If the bound data type is large value type (such as SQLTEXT or SQLIMAGE), pData can be NULL. A NULL pData indicates long data values will be sent to SQL Server in chunks using bcp_moretext.
If pData is set to NULL and the column corresponding to the bound field is not a large value type, bcp_colptr fails.
For more information on large value types, see bcp_bind.
idxServerCol
Is the ordinal position of the column in the database table to which the data is copied. The first column in a table is column 1. The ordinal position of a column is reported by SQLColumns.
SUCCEED or FAIL.
The bcp_colptr function allows you to change the address of source data for a particular column when copying data to SQL Server with bcp_sendrow.
Initially, the pointer to user data is set by a call to bcp_bind. If the program variable data address changes between calls to bcp_sendrow, you can call bcp_colptr to reset the pointer to the data. The next call to bcp_sendrow sends the data addressed by the call to bcp_colptr.
There must be a separate bcp_colptr call for every column in the table whose data address you want to modify.