bcp-getcolfmt.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	apilocation	apiname	apitype
bcp_getcolfmt	bcp_getcolfmt	markingmyname	maghan	03/14/2017	sql	native-client	reference	bcp_getcolfmt function	sqlncli11.dll	bcp_getcolfmt	DLLExport

bcp_getcolfmt

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

Used to find the column format property value.

Syntax

  
RETCODE bcp_getcolfmt (  
        HDBC hdbc,  
        INT field,  
        INT property,  
        void* pValue,  
        INT cbvalue,  
        INT* pcbLen);  

Arguments

hdbc
Is the bulk copy-enabled ODBC connection handle.

field
Is the column number for which the property is retrieved.

property
Is one of the property constants.

pValue
Is the pointer to the buffer from which to retrieve the property value.

cbValue
Is the length of the property buffer in bytes.

pcbLen
Pointer to length of the data that is being returned in the property buffer.

Returns

SUCCEED or FAIL.

Remarks

Column format property values are listed in the bcp_setcolfmt topic. The column format property values are set by calling the bcp_setcolfmt function, and the bcp_getcolfmt function is used to find the column format property value.

Behavior changes may be observed when connecting to a [!INCLUDEssSQL11] (or later) server computer, compared to earlier [!INCLUDEssNoVersion] versions. For more information, see Metadata Discovery.

bcp_getcolfmt Support for Enhanced Date and Time Features

The types used with the BCP_FMT_TYPE property for date/time types are as specified in Bulk Copy Changes for Enhanced Date and Time Types (OLE DB and ODBC).

For more information, see Date and Time Improvements (ODBC).

See Also

Bulk Copy Functions