Package org.lwjgl.odbc

Class SQLNCLI

java.lang.Object

org.lwjgl.odbc.SQLNCLI

public final class SQLNCLI
extends java.lang.Object

Native bindings to the SQL Server Native Client.

Microsoft SQL Server Native Client is a single native dynamic link library (DLL) that contains the ODBC driver and OLE DB provider, which together support applications using native-code APIs (ODBC, OLE DB and ADO) to access Microsoft SQL Server. SQL Server Native Client is a component of SQL Server. It is also available for download from the Feature Pack for Microsoft SQL Server 2005 and Microsoft SQL Server 2008 Feature Pack. In SQL Server Native Client, everything (APIs, TDS routines, and netlibs) is packaged into a single DLL.

Field Summary

Fields

Modifier and Type	Field	Description
static short	EX_ANY EX_CMDFATAL EX_CONTROL EX_DBCORRUPT EX_DBFATAL EX_DEADLOCK EX_HARDWARE EX_INFO EX_INTOK EX_LIMIT EX_MAXISEVERITY EX_MISSING EX_PERMIT EX_RESOURCE EX_SYNTAX EX_TABCORRUPT EX_TYPE EX_USER MAXUSEVERITY	Severity codes for DIAG_SS_SEVERITY.
static short	MIN_USER_DATATYPE	User Data Type definitions.
static short	MINFATALERR	Severity codes for DIAG_SS_SEVERITY.
static short	SQL_AD_DEFAULT SQL_AD_OFF SQL_AD_ON	Defines for use with COPT_SS_ANSI_NPW - Pre-Connect Option only.
static short	SQL_BCP_DEFAULT	Defines for use with COPT_SS_BCP - Pre-Connect Option only.
static int	SQL_BCP_FMT_COLLATION SQL_BCP_FMT_COLLATION_ID SQL_BCP_FMT_DATA_LEN SQL_BCP_FMT_INDICATOR_LEN SQL_BCP_FMT_SERVER_COL SQL_BCP_FMT_TERMINATOR SQL_BCP_FMT_TYPE	BCP column format properties.
static short	SQL_BCP_OFF SQL_BCP_ON	Defines for use with COPT_SS_BCP - Pre-Connect Option only.
static int	SQL_BCP_OUT_CHARACTER_MODE SQL_BCP_OUT_NATIVE_MODE SQL_BCP_OUT_NATIVE_TEXT_MODE SQL_BCP_OUT_WIDE_CHARACTER_MODE	bcp_setbulkmode properties.
static short	SQL_BCPABORT SQL_BCPBATCH SQL_BCPDELAYREADFMT SQL_BCPFILECP	bcp_control option.
static short	SQL_BCPFILECP_ACP SQL_BCPFILECP_OEMCP SQL_BCPFILECP_RAW	BCPFILECP values.
static short	SQL_BCPFILEFMT SQL_BCPFIRST SQL_BCPFIRSTEX SQL_BCPFMTXML SQL_BCPHINTSA SQL_BCPHINTSW SQL_BCPKEEPIDENTITY SQL_BCPKEEPNULLS SQL_BCPLAST SQL_BCPLASTEX SQL_BCPMAXERRS SQL_BCPODBC SQL_BCPROWCOUNT SQL_BCPTEXTFILE SQL_BCPUNICODEFILE	bcp_control option.
static short	SQL_C_SS_TIME2 SQL_C_SS_TIMESTAMPOFFSET SQL_C_TYPES_EXTENDED	Extended C Types range 4000 and above.
static short	SQL_CA_SS_BASE SQL_CA_SS_CATALOG_NAME SQL_CA_SS_COLUMN_COLLATION SQL_CA_SS_COLUMN_COMPUTED SQL_CA_SS_COLUMN_HAS_DEFAULT_VALUE SQL_CA_SS_COLUMN_HIDDEN SQL_CA_SS_COLUMN_ID SQL_CA_SS_COLUMN_IN_UNIQUE_KEY SQL_CA_SS_COLUMN_KEY SQL_CA_SS_COLUMN_OP SQL_CA_SS_COLUMN_ORDER SQL_CA_SS_COLUMN_SIZE SQL_CA_SS_COLUMN_SORT_ORDER SQL_CA_SS_COLUMN_SORT_ORDINAL SQL_CA_SS_COLUMN_SSTYPE SQL_CA_SS_COLUMN_UTYPE SQL_CA_SS_COLUMN_VARYLEN SQL_CA_SS_COMPUTE_BYLIST SQL_CA_SS_COMPUTE_ID SQL_CA_SS_IS_COLUMN_SET SQL_CA_SS_MAX_USED SQL_CA_SS_NUM_COMPUTES SQL_CA_SS_NUM_ORDERS SQL_CA_SS_SCHEMA_NAME SQL_CA_SS_SERVER_TYPE SQL_CA_SS_TYPE_NAME SQL_CA_SS_UDT_ASSEMBLY_TYPE_NAME SQL_CA_SS_UDT_CATALOG_NAME SQL_CA_SS_UDT_SCHEMA_NAME SQL_CA_SS_UDT_TYPE_NAME SQL_CA_SS_VARIANT_SERVER_TYPE SQL_CA_SS_VARIANT_SQL_TYPE SQL_CA_SS_VARIANT_TYPE SQL_CA_SS_XML_SCHEMACOLLECTION_CATALOG_NAME SQL_CA_SS_XML_SCHEMACOLLECTION_NAME SQL_CA_SS_XML_SCHEMACOLLECTION_SCHEMA_NAME	ColAttribute & SetDescField/GetDescField driver specific defines.
static short	SQL_CACHE_DATA_NO SQL_CACHE_DATA_YES	COPT_SS_BROWSE_CACHE_DATA.
static short	SQL_CN_DEFAULT SQL_CN_OFF SQL_CN_ON	Defines for use with COPT_SS_CONCAT_NULL - Pre-Connect Option only.
static short	SQL_CO_AF SQL_CO_DEFAULT SQL_CO_FFO SQL_CO_FFO_AF SQL_CO_FIREHOSE_AF SQL_CO_OFF	Defines for use with SOPT_SS_CURSOR_OPTIONS.
static short	SQL_COPT_SS_ANSI_NPW SQL_COPT_SS_APPLICATION_INTENT SQL_COPT_SS_ATTACHDBFILENAME SQL_COPT_SS_BASE SQL_COPT_SS_BASE_EX SQL_COPT_SS_BCP SQL_COPT_SS_BROWSE_CACHE_DATA SQL_COPT_SS_BROWSE_CONNECT SQL_COPT_SS_BROWSE_SERVER SQL_COPT_SS_CLIENT_CONNECTION_ID SQL_COPT_SS_CONCAT_NULL SQL_COPT_SS_CONNECTION_DEAD SQL_COPT_SS_ENCRYPT SQL_COPT_SS_ENLIST_IN_DTC SQL_COPT_SS_ENLIST_IN_XA SQL_COPT_SS_EX_MAX_USED SQL_COPT_SS_FAILOVER_PARTNER SQL_COPT_SS_FAILOVER_PARTNER_SPN SQL_COPT_SS_FALLBACK_CONNECT SQL_COPT_SS_INTEGRATED_AUTHENTICATION_METHOD SQL_COPT_SS_INTEGRATED_SECURITY SQL_COPT_SS_MARS_ENABLED SQL_COPT_SS_MAX_USED SQL_COPT_SS_MULTISUBNET_FAILOVER SQL_COPT_SS_MUTUALLY_AUTHENTICATED SQL_COPT_SS_OLDPWD SQL_COPT_SS_PERF_DATA SQL_COPT_SS_PERF_DATA_LOG SQL_COPT_SS_PERF_DATA_LOG_NOW SQL_COPT_SS_PERF_QUERY SQL_COPT_SS_PERF_QUERY_INTERVAL SQL_COPT_SS_PERF_QUERY_LOG SQL_COPT_SS_PRESERVE_CURSORS SQL_COPT_SS_QUOTED_IDENT SQL_COPT_SS_REMOTE_PWD SQL_COPT_SS_RESET_CONNECTION SQL_COPT_SS_SERVER_SPN SQL_COPT_SS_TRANSLATE SQL_COPT_SS_TRUST_SERVER_CERTIFICATE SQL_COPT_SS_TXN_ISOLATION SQL_COPT_SS_USE_PROC_FOR_PREP SQL_COPT_SS_USER_DATA SQL_COPT_SS_WARN_ON_CP_ERROR	Connection attributes.
static short	SQL_CURSOR_FAST_FORWARD_ONLY	Defines returned by ATTR_CURSOR_TYPE.
static short	SQL_DB_IN SQL_DB_OUT	BCP Transfer directions.
static short	SQL_DIAG_DFC_SS_ALTER_DATABASE SQL_DIAG_DFC_SS_BACKUP_DATABASE SQL_DIAG_DFC_SS_BACKUP_TRANSACTION SQL_DIAG_DFC_SS_BASE SQL_DIAG_DFC_SS_CHECKPOINT SQL_DIAG_DFC_SS_CONDITION SQL_DIAG_DFC_SS_CREATE_DATABASE SQL_DIAG_DFC_SS_CREATE_DEFAULT SQL_DIAG_DFC_SS_CREATE_PROCEDURE SQL_DIAG_DFC_SS_CREATE_RULE SQL_DIAG_DFC_SS_CREATE_TRIGGER SQL_DIAG_DFC_SS_CURSOR_CLOSE SQL_DIAG_DFC_SS_CURSOR_DECLARE SQL_DIAG_DFC_SS_CURSOR_FETCH SQL_DIAG_DFC_SS_CURSOR_OPEN SQL_DIAG_DFC_SS_DBCC SQL_DIAG_DFC_SS_DEALLOCATE_CURSOR SQL_DIAG_DFC_SS_DENY SQL_DIAG_DFC_SS_DISK SQL_DIAG_DFC_SS_DROP_DATABASE SQL_DIAG_DFC_SS_DROP_DEFAULT SQL_DIAG_DFC_SS_DROP_PROCEDURE SQL_DIAG_DFC_SS_DROP_RULE SQL_DIAG_DFC_SS_DROP_TRIGGER SQL_DIAG_DFC_SS_DUMP_DATABASE SQL_DIAG_DFC_SS_DUMP_TABLE SQL_DIAG_DFC_SS_DUMP_TRANSACTION SQL_DIAG_DFC_SS_GOTO SQL_DIAG_DFC_SS_INSERT_BULK SQL_DIAG_DFC_SS_KILL SQL_DIAG_DFC_SS_LOAD_DATABASE SQL_DIAG_DFC_SS_LOAD_HEADERONLY SQL_DIAG_DFC_SS_LOAD_TABLE SQL_DIAG_DFC_SS_LOAD_TRANSACTION SQL_DIAG_DFC_SS_MERGE SQL_DIAG_DFC_SS_PRINT SQL_DIAG_DFC_SS_RAISERROR SQL_DIAG_DFC_SS_READTEXT SQL_DIAG_DFC_SS_RECONFIGURE SQL_DIAG_DFC_SS_RESTORE_DATABASE SQL_DIAG_DFC_SS_RESTORE_HEADERONLY SQL_DIAG_DFC_SS_RESTORE_TRANSACTION SQL_DIAG_DFC_SS_RETURN SQL_DIAG_DFC_SS_SELECT_INTO SQL_DIAG_DFC_SS_SET SQL_DIAG_DFC_SS_SET_IDENTITY_INSERT SQL_DIAG_DFC_SS_SET_ROW_COUNT SQL_DIAG_DFC_SS_SET_STATISTICS SQL_DIAG_DFC_SS_SET_TEXTSIZE SQL_DIAG_DFC_SS_SET_XCTLVL SQL_DIAG_DFC_SS_SETUSER SQL_DIAG_DFC_SS_SHUTDOWN SQL_DIAG_DFC_SS_TRANS_BEGIN SQL_DIAG_DFC_SS_TRANS_COMMIT SQL_DIAG_DFC_SS_TRANS_PREPARE SQL_DIAG_DFC_SS_TRANS_ROLLBACK SQL_DIAG_DFC_SS_TRANS_SAVE SQL_DIAG_DFC_SS_TRUNCATE_TABLE SQL_DIAG_DFC_SS_UPDATE_STATISTICS SQL_DIAG_DFC_SS_UPDATETEXT SQL_DIAG_DFC_SS_USE SQL_DIAG_DFC_SS_WAITFOR SQL_DIAG_DFC_SS_WRITETEXT	GetDiagField/DIAG_DYNAMIC_FUNCTION_CODE driver specific defines.
static short	SQL_DIAG_SS_BASE SQL_DIAG_SS_LINE SQL_DIAG_SS_MSGSTATE SQL_DIAG_SS_PROCNAME SQL_DIAG_SS_SEVERITY SQL_DIAG_SS_SRVNAME	GetDiagField driver specific defines.
static short	SQL_DP_OFF SQL_DP_ON	SOPT_SS_DEFER_PREPARE.
static short	SQL_EN_OFF SQL_EN_ON	COPT_SS_ENCRYPT.
static short	SQL_FAIL	BCP Return codes.
static short	SQL_FB_DEFAULT SQL_FB_OFF SQL_FB_ON	Defines for use with COPT_SS_FALLBACK_CONNECT - Pre-Connect Option only.
static int	SQL_FILESTREAM_OPEN_FLAG_ASYNC SQL_FILESTREAM_OPEN_FLAG_NO_BUFFERING SQL_FILESTREAM_OPEN_FLAG_NO_WRITE_THROUGH SQL_FILESTREAM_OPEN_FLAG_RANDOM_ACCESS SQL_FILESTREAM_OPEN_FLAG_SEQUENTIAL_SCAN SQL_FILESTREAM_READ SQL_FILESTREAM_READWRITE SQL_FILESTREAM_WRITE	The following facilitates opening a handle to a SQL filestream.
static short	SQL_HC_DEFAULT SQL_HC_OFF SQL_HC_ON	Defines for use with SOPT_SS_HIDDEN_COLUMNS.
static short	SQL_INFO_SS_FIRST SQL_INFO_SS_MAX_USED SQL_INFO_SS_NETLIB_NAME SQL_INFO_SS_NETLIB_NAMEA SQL_INFO_SS_NETLIB_NAMEW	GetInfo driver specific define.
static short	SQL_IS_DEFAULT SQL_IS_OFF SQL_IS_ON	Defines for use with COPT_SS_INTEGRATED_SECURITY - Pre-Connect Option only.
static short	SQL_MARS_ENABLED_NO SQL_MARS_ENABLED_YES	COPT_SS_MARS_ENABLED.
static short	SQL_MAX_SQLSERVERNAME	Max SQL Server identifier length.
static short	SQL_MORE_INFO_NO SQL_MORE_INFO_YES	COPT_SS_BROWSE_CONNECT.
static short	SQL_NB_DEFAULT SQL_NB_OFF SQL_NB_ON	Defines for use with SOPT_SS_NOBROWSETABLE.
static short	SQL_NC_OFF SQL_NC_ON	SOPT_SS_NOCOUNT_STATUS.
static short	SQL_PC_DEFAULT SQL_PC_OFF SQL_PC_ON	Defines for use with COPT_SS_PRESERVE_CURSORS.
static short	SQL_PERF_START SQL_PERF_STOP	Options for COPT_SS_PERF_DATA and COPT_SS_PERF_QUERY.
static short	SQL_QI_DEFAULT SQL_QI_OFF SQL_QI_ON	Defines for use with COPT_SS_QUOTED_IDENT.
static short	SQL_RE_DEFAULT SQL_RE_OFF SQL_RE_ON	Defines for use with SOPT_SS_REGIONALIZE.
static short	SQL_RESET_YES	COPT_SS_RESET_CONNECTION.
static short	SQL_SOPT_SS_BASE SQL_SOPT_SS_CURRENT_COMMAND SQL_SOPT_SS_CURSOR_OPTIONS SQL_SOPT_SS_DEFER_PREPARE SQL_SOPT_SS_HIDDEN_COLUMNS SQL_SOPT_SS_MAX_USED SQL_SOPT_SS_NAME_SCOPE SQL_SOPT_SS_NOBROWSETABLE SQL_SOPT_SS_NOCOUNT_STATUS SQL_SOPT_SS_PARAM_FOCUS SQL_SOPT_SS_QUERYNOTIFICATION_MSGTEXT SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS SQL_SOPT_SS_QUERYNOTIFICATION_TIMEOUT SQL_SOPT_SS_REGIONALIZE SQL_SOPT_SS_TEXTPTR_LOGGING	Statement attributes.
static short	SQL_SS_ASCENDING_ORDER SQL_SS_DESCENDING_ORDER	The following are defines for CA_SS_COLUMN_SORT_ORDER.
static java.lang.String	SQL_SS_DL_DEFAULT	Defines for COPT_SS_PERF_DATA_LOG.
static short	SQL_SS_LENGTH_UNLIMITED	SS_LENGTH_UNLIMITED is used to describe the max length of VARCHAR(max), VARBINARY(max), NVARCHAR(max), and XML columns.
static short	SQL_SS_NAME_SCOPE_DEFAULT SQL_SS_NAME_SCOPE_EXTENDED SQL_SS_NAME_SCOPE_SPARSE_COLUMN_SET SQL_SS_NAME_SCOPE_TABLE SQL_SS_NAME_SCOPE_TABLE_TYPE	SOPT_SS_NAME_SCOPE.
static short	SQL_SS_ORDER_DEFAULT SQL_SS_ORDER_UNSPECIFIED	The following are defines for CA_SS_COLUMN_SORT_ORDER.
static short	SQL_SS_QI_DEFAULT	Defines for COPT_SS_PERF_QUERY_INTERVAL.
static java.lang.String	SQL_SS_QL_DEFAULT	Defines for COPT_SS_PERF_QUERY_LOG.
static short	SQL_SS_TABLE SQL_SS_TIME2 SQL_SS_TIMESTAMPOFFSET	Driver specific SQL data type defines.
static short	SQL_SS_TYPE_DATETIME SQL_SS_TYPE_DEFAULT SQL_SS_TYPE_SMALLDATETIME	Local types to be used with CA_SS_SERVER_TYPE.
static short	SQL_SS_UDT SQL_SS_VARIANT SQL_SS_XML	Driver specific SQL data type defines.
static short	SQL_SUCCEED SQL_SUCCEED_ABORT SQL_SUCCEED_ASYNC	BCP Return codes.
static short	SQL_TL_DEFAULT SQL_TL_OFF SQL_TL_ON	Defines for use with SOPT_SS_TEXTPTR_LOGGING.
static short	SQL_TRUST_SERVER_CERTIFICATE_NO SQL_TRUST_SERVER_CERTIFICATE_YES	COPT_SS_TRUST_SERVER_CERTIFICATE.
static int	SQL_TXN_SS_SNAPSHOT	TXN_ISOLATION_OPTION bitmasks.
static long	SQL_UD_NOTSET	Defines for use with COPT_SS_USER_DATA.
static short	SQL_UP_DEFAULT SQL_UP_OFF SQL_UP_ON SQL_UP_ON_DROP	Defines for use with COPT_SS_USE_PROC_FOR_PREP.
static short	SQL_VARLEN_DATA	bcp_collen definition.
static short	SQL_WARN_NO SQL_WARN_YES	COPT_SS_WARN_ON_CP_ERROR.
static short	SQL_XL_DEFAULT SQL_XL_OFF SQL_XL_ON	Defines for use with COPT_SS_TRANSLATE.
static int	SQLAOPANY SQLAOPAVG SQLAOPCNT SQLAOPMAX SQLAOPMIN SQLAOPNOOP SQLAOPSTDEV SQLAOPSTDEVP SQLAOPSUM SQLAOPVAR SQLAOPVARP	Aggregate operator types.
static short	SQLBIGBINARY SQLBIGCHAR SQLBIGVARBINARY SQLBIGVARCHAR SQLBINARY SQLBIT SQLBITN SQLCHARACTER SQLDATEN SQLDATETIM4 SQLDATETIME SQLDATETIME2N SQLDATETIMEOFFSETN SQLDATETIMN SQLDECIMAL SQLDECIMALN SQLFLT4 SQLFLT8 SQLFLTN SQLIMAGE SQLINT1 SQLINT2 SQLINT4 SQLINT8 SQLINTN SQLMONEY SQLMONEY4 SQLMONEYN SQLNCHAR SQLNTEXT SQLNUMERIC SQLNUMERICN SQLNVARCHAR SQLTABLE SQLTEXT SQLTIMEN SQLUDT	New types for SQL 6.0 and later servers.
static short	SQLudtBINARY SQLudtBIT SQLudtBITN SQLudtCHAR SQLudtDATETIM4 SQLudtDATETIME SQLudtDATETIMN SQLudtDECML SQLudtDECMLN SQLudtFLT4 SQLudtFLT8 SQLudtFLTN SQLudtIMAGE SQLudtINT1 SQLudtINT2 SQLudtINT4 SQLudtINTN SQLudtMONEY SQLudtMONEY4 SQLudtMONEYN SQLudtNUM SQLudtNUMN SQLudtSYSNAME SQLudtTEXT SQLudtTIMESTAMP SQLudtUNIQUEIDENTIFIER SQLudtVARBINARY SQLudtVARCHAR	User Data Type definitions.
static short	SQLUNIQUEID SQLVARBINARY SQLVARCHAR SQLVARIANT SQLXML	New types for SQL 6.0 and later servers.

Method Summary

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

SQL_MAX_SQLSERVERNAME

Max SQL Server identifier length.

SQL_COPT_SS_BASE, SQL_COPT_SS_REMOTE_PWD, SQL_COPT_SS_USE_PROC_FOR_PREP, SQL_COPT_SS_INTEGRATED_SECURITY, SQL_COPT_SS_PRESERVE_CURSORS, SQL_COPT_SS_USER_DATA, SQL_COPT_SS_ENLIST_IN_DTC, SQL_COPT_SS_ENLIST_IN_XA, SQL_COPT_SS_FALLBACK_CONNECT, SQL_COPT_SS_PERF_DATA, SQL_COPT_SS_PERF_DATA_LOG, SQL_COPT_SS_PERF_QUERY_INTERVAL, SQL_COPT_SS_PERF_QUERY_LOG, SQL_COPT_SS_PERF_QUERY, SQL_COPT_SS_PERF_DATA_LOG_NOW, SQL_COPT_SS_QUOTED_IDENT, SQL_COPT_SS_ANSI_NPW, SQL_COPT_SS_BCP, SQL_COPT_SS_TRANSLATE, SQL_COPT_SS_ATTACHDBFILENAME, SQL_COPT_SS_CONCAT_NULL, SQL_COPT_SS_ENCRYPT, SQL_COPT_SS_MARS_ENABLED, SQL_COPT_SS_FAILOVER_PARTNER, SQL_COPT_SS_OLDPWD, SQL_COPT_SS_TXN_ISOLATION, SQL_COPT_SS_TRUST_SERVER_CERTIFICATE, SQL_COPT_SS_SERVER_SPN, SQL_COPT_SS_FAILOVER_PARTNER_SPN, SQL_COPT_SS_INTEGRATED_AUTHENTICATION_METHOD, SQL_COPT_SS_MUTUALLY_AUTHENTICATED, SQL_COPT_SS_CLIENT_CONNECTION_ID, SQL_COPT_SS_MAX_USED, SQL_COPT_SS_BASE_EX, SQL_COPT_SS_BROWSE_CONNECT, SQL_COPT_SS_BROWSE_SERVER, SQL_COPT_SS_WARN_ON_CP_ERROR, SQL_COPT_SS_CONNECTION_DEAD, SQL_COPT_SS_BROWSE_CACHE_DATA, SQL_COPT_SS_RESET_CONNECTION, SQL_COPT_SS_APPLICATION_INTENT, SQL_COPT_SS_MULTISUBNET_FAILOVER, SQL_COPT_SS_EX_MAX_USED

Connection attributes.

SQL_SOPT_SS_BASE, SQL_SOPT_SS_TEXTPTR_LOGGING, SQL_SOPT_SS_CURRENT_COMMAND, SQL_SOPT_SS_HIDDEN_COLUMNS, SQL_SOPT_SS_NOBROWSETABLE, SQL_SOPT_SS_REGIONALIZE, SQL_SOPT_SS_CURSOR_OPTIONS, SQL_SOPT_SS_NOCOUNT_STATUS, SQL_SOPT_SS_DEFER_PREPARE, SQL_SOPT_SS_QUERYNOTIFICATION_TIMEOUT, SQL_SOPT_SS_QUERYNOTIFICATION_MSGTEXT, SQL_SOPT_SS_QUERYNOTIFICATION_OPTIONS, SQL_SOPT_SS_PARAM_FOCUS, SQL_SOPT_SS_NAME_SCOPE, SQL_SOPT_SS_MAX_USED

Statement attributes.

SQL_CA_SS_BASE, SQL_CA_SS_COLUMN_SSTYPE, SQL_CA_SS_COLUMN_UTYPE, SQL_CA_SS_NUM_ORDERS, SQL_CA_SS_COLUMN_ORDER, SQL_CA_SS_COLUMN_VARYLEN, SQL_CA_SS_NUM_COMPUTES, SQL_CA_SS_COMPUTE_ID, SQL_CA_SS_COMPUTE_BYLIST, SQL_CA_SS_COLUMN_ID, SQL_CA_SS_COLUMN_OP, SQL_CA_SS_COLUMN_SIZE, SQL_CA_SS_COLUMN_HIDDEN, SQL_CA_SS_COLUMN_KEY, SQL_CA_SS_COLUMN_COLLATION, SQL_CA_SS_VARIANT_TYPE, SQL_CA_SS_VARIANT_SQL_TYPE, SQL_CA_SS_VARIANT_SERVER_TYPE, SQL_CA_SS_UDT_CATALOG_NAME, SQL_CA_SS_UDT_SCHEMA_NAME, SQL_CA_SS_UDT_TYPE_NAME, SQL_CA_SS_UDT_ASSEMBLY_TYPE_NAME, SQL_CA_SS_XML_SCHEMACOLLECTION_CATALOG_NAME, SQL_CA_SS_XML_SCHEMACOLLECTION_SCHEMA_NAME, SQL_CA_SS_XML_SCHEMACOLLECTION_NAME, SQL_CA_SS_CATALOG_NAME, SQL_CA_SS_SCHEMA_NAME, SQL_CA_SS_TYPE_NAME, SQL_CA_SS_COLUMN_COMPUTED, SQL_CA_SS_COLUMN_IN_UNIQUE_KEY, SQL_CA_SS_COLUMN_SORT_ORDER, SQL_CA_SS_COLUMN_SORT_ORDINAL, SQL_CA_SS_COLUMN_HAS_DEFAULT_VALUE, SQL_CA_SS_IS_COLUMN_SET, SQL_CA_SS_SERVER_TYPE, SQL_CA_SS_MAX_USED

ColAttribute & SetDescField/GetDescField driver specific defines.

SQL_CURSOR_FAST_FORWARD_ONLY

Defines returned by ATTR_CURSOR_TYPE.

SQL_UP_OFF, SQL_UP_ON, SQL_UP_ON_DROP, SQL_UP_DEFAULT

Defines for use with COPT_SS_USE_PROC_FOR_PREP.

SQL_IS_OFF, SQL_IS_ON, SQL_IS_DEFAULT

Defines for use with COPT_SS_INTEGRATED_SECURITY - Pre-Connect Option only.

SQL_PC_OFF, SQL_PC_ON, SQL_PC_DEFAULT

Defines for use with COPT_SS_PRESERVE_CURSORS.

SQL_UD_NOTSET

Defines for use with COPT_SS_USER_DATA.

SQL_XL_OFF, SQL_XL_ON, SQL_XL_DEFAULT

Defines for use with COPT_SS_TRANSLATE.

SQL_FB_OFF, SQL_FB_ON, SQL_FB_DEFAULT

Defines for use with COPT_SS_FALLBACK_CONNECT - Pre-Connect Option only.

SQL_BCP_OFF, SQL_BCP_ON, SQL_BCP_DEFAULT

Defines for use with COPT_SS_BCP - Pre-Connect Option only.

SQL_QI_OFF, SQL_QI_ON, SQL_QI_DEFAULT

Defines for use with COPT_SS_QUOTED_IDENT.

SQL_AD_OFF, SQL_AD_ON, SQL_AD_DEFAULT

Defines for use with COPT_SS_ANSI_NPW - Pre-Connect Option only.

SQL_CN_OFF, SQL_CN_ON, SQL_CN_DEFAULT

Defines for use with COPT_SS_CONCAT_NULL - Pre-Connect Option only.

SQL_TL_OFF, SQL_TL_ON, SQL_TL_DEFAULT

Defines for use with SOPT_SS_TEXTPTR_LOGGING.

SQL_HC_OFF, SQL_HC_ON, SQL_HC_DEFAULT

Defines for use with SOPT_SS_HIDDEN_COLUMNS.

SQL_NB_OFF, SQL_NB_ON, SQL_NB_DEFAULT

Defines for use with SOPT_SS_NOBROWSETABLE.

SQL_RE_OFF, SQL_RE_ON, SQL_RE_DEFAULT

Defines for use with SOPT_SS_REGIONALIZE.

SQL_CO_OFF, SQL_CO_FFO, SQL_CO_AF, SQL_CO_FFO_AF, SQL_CO_FIREHOSE_AF, SQL_CO_DEFAULT

Defines for use with SOPT_SS_CURSOR_OPTIONS.

SQL_NC_OFF, SQL_NC_ON

SOPT_SS_NOCOUNT_STATUS.

SQL_DP_OFF, SQL_DP_ON

SOPT_SS_DEFER_PREPARE.

SQL_SS_NAME_SCOPE_TABLE, SQL_SS_NAME_SCOPE_TABLE_TYPE, SQL_SS_NAME_SCOPE_EXTENDED, SQL_SS_NAME_SCOPE_SPARSE_COLUMN_SET, SQL_SS_NAME_SCOPE_DEFAULT

SOPT_SS_NAME_SCOPE.

SQL_EN_OFF, SQL_EN_ON

COPT_SS_ENCRYPT.

SQL_TRUST_SERVER_CERTIFICATE_NO, SQL_TRUST_SERVER_CERTIFICATE_YES

COPT_SS_TRUST_SERVER_CERTIFICATE.

SQL_MORE_INFO_NO, SQL_MORE_INFO_YES

COPT_SS_BROWSE_CONNECT.

SQL_CACHE_DATA_NO, SQL_CACHE_DATA_YES

COPT_SS_BROWSE_CACHE_DATA.

SQL_RESET_YES

COPT_SS_RESET_CONNECTION.

SQL_WARN_NO, SQL_WARN_YES

COPT_SS_WARN_ON_CP_ERROR.

SQL_MARS_ENABLED_NO, SQL_MARS_ENABLED_YES

COPT_SS_MARS_ENABLED.

SQL_TXN_SS_SNAPSHOT

TXN_ISOLATION_OPTION bitmasks.

SQL_SS_ORDER_UNSPECIFIED, SQL_SS_DESCENDING_ORDER, SQL_SS_ASCENDING_ORDER, SQL_SS_ORDER_DEFAULT

The following are defines for CA_SS_COLUMN_SORT_ORDER.

SQL_SS_VARIANT, SQL_SS_UDT, SQL_SS_XML, SQL_SS_TABLE, SQL_SS_TIME2, SQL_SS_TIMESTAMPOFFSET

Driver specific SQL data type defines.

SQL_SS_TYPE_DEFAULT, SQL_SS_TYPE_SMALLDATETIME, SQL_SS_TYPE_DATETIME

Local types to be used with CA_SS_SERVER_TYPE.

SQL_C_TYPES_EXTENDED, SQL_C_SS_TIME2, SQL_C_SS_TIMESTAMPOFFSET

Extended C Types range 4000 and above.

SQLTEXT, SQLVARBINARY, SQLINTN, SQLVARCHAR, SQLBINARY, SQLIMAGE, SQLCHARACTER, SQLINT1, SQLBIT, SQLINT2, SQLINT4, SQLMONEY, SQLDATETIME, SQLFLT8, SQLFLTN, SQLMONEYN, SQLDATETIMN, SQLFLT4, SQLMONEY4, SQLDATETIM4, SQLDECIMAL, SQLNUMERIC, SQLUNIQUEID, SQLBIGCHAR, SQLBIGVARCHAR, SQLBIGBINARY, SQLBIGVARBINARY, SQLBITN, SQLNCHAR, SQLNVARCHAR, SQLNTEXT, SQLINT8, SQLVARIANT, SQLUDT, SQLXML, SQLTABLE, SQLDATEN, SQLTIMEN, SQLDATETIME2N, SQLDATETIMEOFFSETN, SQLDECIMALN, SQLNUMERICN

New types for SQL 6.0 and later servers.

SQL_SS_LENGTH_UNLIMITED

SS_LENGTH_UNLIMITED is used to describe the max length of VARCHAR(max), VARBINARY(max), NVARCHAR(max), and XML columns.

SQLudtBINARY, SQLudtBIT, SQLudtBITN, SQLudtCHAR, SQLudtDATETIM4, SQLudtDATETIME, SQLudtDATETIMN, SQLudtDECML, SQLudtDECMLN, SQLudtFLT4, SQLudtFLT8, SQLudtFLTN, SQLudtIMAGE, SQLudtINT1, SQLudtINT2, SQLudtINT4, SQLudtINTN, SQLudtMONEY, SQLudtMONEY4, SQLudtMONEYN, SQLudtNUM, SQLudtNUMN, SQLudtSYSNAME, SQLudtTEXT, SQLudtTIMESTAMP, SQLudtUNIQUEIDENTIFIER, SQLudtVARBINARY, SQLudtVARCHAR, MIN_USER_DATATYPE

User Data Type definitions. Returned by ColAttribute/CA_SS_COLUMN_UTYPE.

SQLAOPSTDEV, SQLAOPSTDEVP, SQLAOPVAR, SQLAOPVARP, SQLAOPCNT, SQLAOPSUM, SQLAOPAVG, SQLAOPMIN, SQLAOPMAX, SQLAOPANY, SQLAOPNOOP

Aggregate operator types. Returned by ColAttribute/CA_SS_COLUMN_OP.

SQL_INFO_SS_FIRST, SQL_INFO_SS_NETLIB_NAMEW, SQL_INFO_SS_NETLIB_NAMEA, SQL_INFO_SS_MAX_USED, SQL_INFO_SS_NETLIB_NAME

GetInfo driver specific define.

SQL_DIAG_SS_BASE, SQL_DIAG_SS_MSGSTATE, SQL_DIAG_SS_SEVERITY, SQL_DIAG_SS_SRVNAME, SQL_DIAG_SS_PROCNAME, SQL_DIAG_SS_LINE

GetDiagField driver specific defines.

SQL_DIAG_DFC_SS_BASE, SQL_DIAG_DFC_SS_ALTER_DATABASE, SQL_DIAG_DFC_SS_CHECKPOINT, SQL_DIAG_DFC_SS_CONDITION, SQL_DIAG_DFC_SS_CREATE_DATABASE, SQL_DIAG_DFC_SS_CREATE_DEFAULT, SQL_DIAG_DFC_SS_CREATE_PROCEDURE, SQL_DIAG_DFC_SS_CREATE_RULE, SQL_DIAG_DFC_SS_CREATE_TRIGGER, SQL_DIAG_DFC_SS_CURSOR_DECLARE, SQL_DIAG_DFC_SS_CURSOR_OPEN, SQL_DIAG_DFC_SS_CURSOR_FETCH, SQL_DIAG_DFC_SS_CURSOR_CLOSE, SQL_DIAG_DFC_SS_DEALLOCATE_CURSOR, SQL_DIAG_DFC_SS_DBCC, SQL_DIAG_DFC_SS_DISK, SQL_DIAG_DFC_SS_DROP_DATABASE, SQL_DIAG_DFC_SS_DROP_DEFAULT, SQL_DIAG_DFC_SS_DROP_PROCEDURE, SQL_DIAG_DFC_SS_DROP_RULE, SQL_DIAG_DFC_SS_DROP_TRIGGER, SQL_DIAG_DFC_SS_DUMP_DATABASE, SQL_DIAG_DFC_SS_BACKUP_DATABASE, SQL_DIAG_DFC_SS_DUMP_TABLE, SQL_DIAG_DFC_SS_DUMP_TRANSACTION, SQL_DIAG_DFC_SS_BACKUP_TRANSACTION, SQL_DIAG_DFC_SS_GOTO, SQL_DIAG_DFC_SS_INSERT_BULK, SQL_DIAG_DFC_SS_KILL, SQL_DIAG_DFC_SS_LOAD_DATABASE, SQL_DIAG_DFC_SS_RESTORE_DATABASE, SQL_DIAG_DFC_SS_LOAD_HEADERONLY, SQL_DIAG_DFC_SS_RESTORE_HEADERONLY, SQL_DIAG_DFC_SS_LOAD_TABLE, SQL_DIAG_DFC_SS_LOAD_TRANSACTION, SQL_DIAG_DFC_SS_RESTORE_TRANSACTION, SQL_DIAG_DFC_SS_PRINT, SQL_DIAG_DFC_SS_RAISERROR, SQL_DIAG_DFC_SS_READTEXT, SQL_DIAG_DFC_SS_RECONFIGURE, SQL_DIAG_DFC_SS_RETURN, SQL_DIAG_DFC_SS_SELECT_INTO, SQL_DIAG_DFC_SS_SET, SQL_DIAG_DFC_SS_SET_IDENTITY_INSERT, SQL_DIAG_DFC_SS_SET_ROW_COUNT, SQL_DIAG_DFC_SS_SET_STATISTICS, SQL_DIAG_DFC_SS_SET_TEXTSIZE, SQL_DIAG_DFC_SS_SETUSER, SQL_DIAG_DFC_SS_SHUTDOWN, SQL_DIAG_DFC_SS_TRANS_BEGIN, SQL_DIAG_DFC_SS_TRANS_COMMIT, SQL_DIAG_DFC_SS_TRANS_PREPARE, SQL_DIAG_DFC_SS_TRANS_ROLLBACK, SQL_DIAG_DFC_SS_TRANS_SAVE, SQL_DIAG_DFC_SS_TRUNCATE_TABLE, SQL_DIAG_DFC_SS_UPDATE_STATISTICS, SQL_DIAG_DFC_SS_UPDATETEXT, SQL_DIAG_DFC_SS_USE, SQL_DIAG_DFC_SS_WAITFOR, SQL_DIAG_DFC_SS_WRITETEXT, SQL_DIAG_DFC_SS_DENY, SQL_DIAG_DFC_SS_SET_XCTLVL, SQL_DIAG_DFC_SS_MERGE

GetDiagField/DIAG_DYNAMIC_FUNCTION_CODE driver specific defines.

EX_ANY, EX_INFO, EX_MAXISEVERITY, EX_MISSING, EX_TYPE, EX_DEADLOCK, EX_PERMIT, EX_SYNTAX, EX_USER, EX_RESOURCE, EX_INTOK, MAXUSEVERITY, EX_LIMIT, EX_CMDFATAL, MINFATALERR, EX_DBFATAL, EX_TABCORRUPT, EX_DBCORRUPT, EX_HARDWARE, EX_CONTROL

Severity codes for DIAG_SS_SEVERITY.

SQL_PERF_START, SQL_PERF_STOP

Options for COPT_SS_PERF_DATA and COPT_SS_PERF_QUERY.

SQL_SS_DL_DEFAULT

Defines for COPT_SS_PERF_DATA_LOG.

SQL_SS_QL_DEFAULT

Defines for COPT_SS_PERF_QUERY_LOG.

SQL_SS_QI_DEFAULT

Defines for COPT_SS_PERF_QUERY_INTERVAL.

SQL_SUCCEED, SQL_FAIL, SQL_SUCCEED_ABORT, SQL_SUCCEED_ASYNC

BCP Return codes.

SQL_DB_IN, SQL_DB_OUT

BCP Transfer directions.

SQL_BCPMAXERRS, SQL_BCPFIRST, SQL_BCPLAST, SQL_BCPBATCH, SQL_BCPKEEPNULLS, SQL_BCPABORT, SQL_BCPODBC, SQL_BCPKEEPIDENTITY, SQL_BCPHINTSA, SQL_BCPHINTSW, SQL_BCPFILECP, SQL_BCPUNICODEFILE, SQL_BCPTEXTFILE, SQL_BCPFILEFMT, SQL_BCPFMTXML, SQL_BCPFIRSTEX, SQL_BCPLASTEX, SQL_BCPROWCOUNT, SQL_BCPDELAYREADFMT

bcp_control option.

SQL_BCPFILECP_ACP, SQL_BCPFILECP_OEMCP, SQL_BCPFILECP_RAW

BCPFILECP values.

SQL_VARLEN_DATA

bcp_collen definition.

SQL_BCP_FMT_TYPE, SQL_BCP_FMT_INDICATOR_LEN, SQL_BCP_FMT_DATA_LEN, SQL_BCP_FMT_TERMINATOR, SQL_BCP_FMT_SERVER_COL, SQL_BCP_FMT_COLLATION, SQL_BCP_FMT_COLLATION_ID

BCP column format properties.

SQL_BCP_OUT_CHARACTER_MODE, SQL_BCP_OUT_WIDE_CHARACTER_MODE, SQL_BCP_OUT_NATIVE_TEXT_MODE, SQL_BCP_OUT_NATIVE_MODE

bcp_setbulkmode properties.

SQL_FILESTREAM_READ, SQL_FILESTREAM_WRITE, SQL_FILESTREAM_READWRITE, SQL_FILESTREAM_OPEN_FLAG_ASYNC, SQL_FILESTREAM_OPEN_FLAG_NO_BUFFERING, SQL_FILESTREAM_OPEN_FLAG_NO_WRITE_THROUGH, SQL_FILESTREAM_OPEN_FLAG_SEQUENTIAL_SCAN, SQL_FILESTREAM_OPEN_FLAG_RANDOM_ACCESS

The following facilitates opening a handle to a SQL filestream.