Package org.lwjgl.odbc
Class SQL
- java.lang.Object
-
- org.lwjgl.odbc.SQL
-
public class SQL extends java.lang.ObjectNative bindings to ODBC.The Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). ODBC is a low-level, high-performance interface that is designed specifically for relational data stores.
The ODBC interface allows maximum interoperability — an application can access data in diverse DBMSs through a single interface. Moreover, that application will be independent of any DBMS from which it accesses data. Users of the application can add software components called drivers, which interface between an application and a specific DBMS.
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static classSQL.FunctionsContains the function pointers loaded from the odbcSharedLibrary.
-
Field Summary
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static SharedLibrarygetLibrary()Returns the odbcSharedLibrary.static shortnSQLAllocHandle(short HandleType, long InputHandle, long OutputHandle)Unsafe version of:AllocHandlestatic shortnSQLAllocHandleStd(short fHandleType, long hInput, long phOutput)static shortnSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, long TargetValuePtr, long BufferLength, long StrLen_or_Ind)Unsafe version of:BindColstatic shortnSQLBindParameter(long StatementHandle, short ParameterNumber, short InputOutputType, short ValueType, short ParameterType, long ColumnSize, short DecimalDigits, long ParameterValuePtr, long BufferLength, long StrLen_or_IndPtr)Unsafe version of:BindParameterstatic shortnSQLBrowseConnect(long ConnectionHandle, long InConnectionString, short StringLength1, long OutConnectionString, short BufferLength, long StringLength2Ptr)Unsafe version of:BrowseConnectstatic shortnSQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, long CharacterAttributePtr, short BufferLength, long StringLengthPtr, long NumericAttributePtr)Unsafe version of:ColAttributestatic shortnSQLColumnPrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName, long szColumnName, short cchColumnName)static shortnSQLColumns(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long ColumnName, short NameLength4)static shortnSQLCompleteAsync(short HandleType, long Handle, long AsyncRetCodePtr)Unsafe version of:CompleteAsyncstatic shortnSQLConnect(long ConnectionHandle, long ServerName, short NameLength1, long UserName, short NameLength2, long Authentication, short NameLength3)Unsafe version of:Connectstatic shortnSQLDataSources(long EnvironmentHandle, short Direction, long ServerName, short BufferLength1, long NameLength1Ptr, long Description, short BufferLength2, long NameLength2Ptr)Unsafe version of:DataSourcesstatic shortnSQLDescribeCol(long StatementHandle, short ColumnNumber, long ColumnName, short BufferLength, long NameLengthPtr, long DataTypePtr, long ColumnSizePtr, long DecimalDigitsPtr, long NullablePtr)Unsafe version of:DescribeColstatic shortnSQLDescribeParam(long StatementHandle, short ParameterNumber, long DataTypePtr, long ParameterSizePtr, long DecimalDigitsPtr, long NullablePtr)Unsafe version of:DescribeParamstatic shortnSQLDriverConnect(long ConnectionHandle, long WindowHandle, long InConnectionString, short StringLength1, long OutConnectionString, short BufferLength, long StringLength2Ptr, short DriverCompletion)Unsafe version of:DriverConnectstatic shortnSQLDrivers(long EnvironmentHandle, short Direction, long DriverDescription, short BufferLength1, long DescriptionLengthPtr, long DriverAttributes, short BufferLength2, long AttributesLengthPtr)Unsafe version of:Driversstatic shortnSQLExecDirect(long StatementHandle, long StatementText, int TextLength)Unsafe version of:ExecDirectstatic shortnSQLExtendedFetch(long hstmt, short fFetchType, long irow, long pcrow, long rgfRowStatus)static shortnSQLForeignKeys(long hstmt, long szPkCatalogName, short cchPkCatalogName, long szPkSchemaName, short cchPkSchemaName, long szPkTableName, short cchPkTableName, long szFkCatalogName, short cchFkCatalogName, long szFkSchemaName, short cchFkSchemaName, long szFkTableName, short cchFkTableName)static shortnSQLGetConnectAttr(long ConnectionHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetConnectAttrstatic shortnSQLGetCursorName(long StatementHandle, long CursorName, short BufferLength, long NameLengthPtr)Unsafe version of:GetCursorNamestatic shortnSQLGetData(long StatementHandle, short Col_or_Param_Num, short TargetType, long TargetValuePtr, long BufferLength, long StrLen_or_IndPtr)Unsafe version of:GetDatastatic shortnSQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetDescFieldstatic shortnSQLGetDescRec(long DescriptorHandle, short RecNumber, long Name, short BufferLength, long StringLengthPtr, long TypePtr, long SubTypePtr, long LengthPtr, long PrecisionPtr, long ScalePtr, long NullablePtr)Unsafe version of:GetDescRecstatic shortnSQLGetDiagField(short HandleType, long Handle, short RecNumber, short DiagIdentifier, long DiagInfoPtr, short BufferLength, long StringLengthPtr)Unsafe version of:GetDiagFieldstatic shortnSQLGetDiagRec(short HandleType, long Handle, short RecNumber, long SQLState, long NativeErrorPtr, long MessageText, short BufferLength, long TextLengthPtr)Unsafe version of:GetDiagRecstatic shortnSQLGetEnvAttr(long EnvironmentHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetEnvAttrstatic shortnSQLGetFunctions(long ConnectionHandle, short FunctionId, long SupportedPtr)Unsafe version of:GetFunctionsstatic shortnSQLGetInfo(long ConnectionHandle, short InfoType, long InfoValuePtr, short BufferLength, long StringLengthPtr)Unsafe version of:GetInfostatic shortnSQLGetStmtAttr(long StatementHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetStmtAttrstatic shortnSQLNativeSql(long ConnectionHandle, long InStatementText, int TextLength1, long OutStatementText, int BufferLength, long TextLength2Ptr)Unsafe version of:NativeSqlstatic shortnSQLNumParams(long StatementHandle, long ParameterCountPtr)Unsafe version of:NumParamsstatic shortnSQLNumResultCols(long StatementHandle, long ColumnCountPtr)Unsafe version of:NumResultColsstatic shortnSQLParamData(long StatementHandle, long ValuePtrPtr)Unsafe version of:ParamDatastatic shortnSQLParamOptions(long hstmt, long crow, long pirow)static shortnSQLPrepare(long StatementHandle, long StatementText, int TextLength)Unsafe version of:Preparestatic shortnSQLPrimaryKeys(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)static shortnSQLProcedureColumns(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName, long szColumnName, short cchColumnName)static shortnSQLProcedures(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName)static shortnSQLPutData(long StatementHandle, long DataPtr, long StrLen_or_Ind)Unsafe version of:PutDatastatic shortnSQLRowCount(long StatementHandle, long RowCountPtr)Unsafe version of:RowCountstatic shortnSQLSetConnectAttr(long ConnectionHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetConnectAttrstatic shortnSQLSetCursorName(long StatementHandle, long CursorName, short NameLength)Unsafe version of:SetCursorNamestatic shortnSQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength)Unsafe version of:SetDescFieldstatic shortnSQLSetDescRec(long DescriptorHandle, short RecNumber, short Type, short SubType, long Length, short Precision, short Scale, long DataPtr, long StringLengthPtr, long IndicatorPtr)Unsafe version of:SetDescRecstatic shortnSQLSetEnvAttr(long EnvironmentHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetEnvAttrstatic shortnSQLSetStmtAttr(long StatementHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetStmtAttrstatic shortnSQLSpecialColumns(long StatementHandle, short IdentifierType, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Scope, short Nullable)static shortnSQLStatistics(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Unique, short Reserved)static shortnSQLTablePrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)static shortnSQLTables(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long TableType, short NameLength4)static shortSQLAllocHandle(short HandleType, long InputHandle, PointerBuffer OutputHandle)static shortSQLAllocHandleStd(short fHandleType, long hInput, PointerBuffer phOutput)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.ByteBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.DoubleBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.FloatBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.IntBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.LongBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, java.nio.ShortBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)static shortSQLBindParameter(long StatementHandle, short ParameterNumber, short InputOutputType, short ValueType, short ParameterType, long ColumnSize, short DecimalDigits, java.nio.ByteBuffer ParameterValuePtr, PointerBuffer StrLen_or_IndPtr)static shortSQLBrowseConnect(long ConnectionHandle, java.lang.CharSequence InConnectionString, java.nio.ByteBuffer OutConnectionString, java.nio.ShortBuffer StringLength2Ptr)static shortSQLBrowseConnect(long ConnectionHandle, java.nio.ByteBuffer InConnectionString, java.nio.ByteBuffer OutConnectionString, java.nio.ShortBuffer StringLength2Ptr)static shortSQLBulkOperations(long StatementHandle, short Operation)static shortSQLCancel(long StatementHandle)static shortSQLCancelHandle(short HandleType, long Handle)static shortSQLCloseCursor(long StatementHandle)static shortSQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, java.nio.ByteBuffer CharacterAttributePtr, java.nio.ShortBuffer StringLengthPtr, PointerBuffer NumericAttributePtr)static shortSQLColumnPrivileges(long hstmt, java.nio.ByteBuffer szCatalogName, java.nio.ByteBuffer szSchemaName, java.nio.ByteBuffer szTableName, java.nio.ByteBuffer szColumnName)static shortSQLColumns(long StatementHandle, java.nio.ByteBuffer CatalogName, java.nio.ByteBuffer SchemaName, java.nio.ByteBuffer TableName, java.nio.ByteBuffer ColumnName)static shortSQLCompleteAsync(short HandleType, long Handle, java.nio.ShortBuffer AsyncRetCodePtr)SQLCompleteAsync can be used to determine when an asynchronous function is complete using either notification- or polling-based processing.static shortSQLConnect(long ConnectionHandle, java.lang.CharSequence ServerName, java.lang.CharSequence UserName, java.lang.CharSequence Authentication)static shortSQLConnect(long ConnectionHandle, java.nio.ByteBuffer ServerName, java.nio.ByteBuffer UserName, java.nio.ByteBuffer Authentication)static shortSQLCopyDesc(long SourceDescHandle, long TargetDescHandle)static shortSQLDataSources(long EnvironmentHandle, short Direction, java.nio.ByteBuffer ServerName, java.nio.ShortBuffer NameLength1Ptr, java.nio.ByteBuffer Description, java.nio.ShortBuffer NameLength2Ptr)static shortSQLDescribeCol(long StatementHandle, short ColumnNumber, java.nio.ByteBuffer ColumnName, java.nio.ShortBuffer NameLengthPtr, java.nio.ShortBuffer DataTypePtr, PointerBuffer ColumnSizePtr, java.nio.ShortBuffer DecimalDigitsPtr, java.nio.ShortBuffer NullablePtr)static shortSQLDescribeParam(long StatementHandle, short ParameterNumber, java.nio.ShortBuffer DataTypePtr, PointerBuffer ParameterSizePtr, java.nio.ShortBuffer DecimalDigitsPtr, java.nio.ShortBuffer NullablePtr)static shortSQLDisconnect(long ConnectionHandle)static shortSQLDriverConnect(long ConnectionHandle, long WindowHandle, java.lang.CharSequence InConnectionString, java.nio.ByteBuffer OutConnectionString, java.nio.ShortBuffer StringLength2Ptr, short DriverCompletion)static shortSQLDriverConnect(long ConnectionHandle, long WindowHandle, java.nio.ByteBuffer InConnectionString, java.nio.ByteBuffer OutConnectionString, java.nio.ShortBuffer StringLength2Ptr, short DriverCompletion)static shortSQLDrivers(long EnvironmentHandle, short Direction, java.nio.ByteBuffer DriverDescription, java.nio.ShortBuffer DescriptionLengthPtr, java.nio.ByteBuffer DriverAttributes, java.nio.ShortBuffer AttributesLengthPtr)static shortSQLEndTran(short HandleType, long Handle, short CompletionType)static shortSQLExecDirect(long StatementHandle, java.lang.CharSequence StatementText)static shortSQLExecDirect(long StatementHandle, java.nio.ByteBuffer StatementText)static shortSQLExecute(long StatementHandle)static shortSQLExtendedFetch(long hstmt, short fFetchType, long irow, PointerBuffer pcrow, java.nio.ShortBuffer rgfRowStatus)static shortSQLFetch(long StatementHandle)static shortSQLFetchScroll(long StatementHandle, short FetchOrientation, long FetchOffset)static shortSQLForeignKeys(long hstmt, java.nio.ByteBuffer szPkCatalogName, java.nio.ByteBuffer szPkSchemaName, java.nio.ByteBuffer szPkTableName, java.nio.ByteBuffer szFkCatalogName, java.nio.ByteBuffer szFkSchemaName, java.nio.ByteBuffer szFkTableName)static shortSQLFreeHandle(short HandleType, long Handle)static shortSQLFreeStmt(long StatementHandle, short Option)static shortSQLGetConnectAttr(long ConnectionHandle, int Attribute, java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)static shortSQLGetCursorName(long StatementHandle, java.nio.ByteBuffer CursorName, java.nio.ShortBuffer NameLengthPtr)static shortSQLGetData(long StatementHandle, short Col_or_Param_Num, short TargetType, java.nio.ByteBuffer TargetValuePtr, PointerBuffer StrLen_or_IndPtr)static shortSQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)static shortSQLGetDescRec(long DescriptorHandle, short RecNumber, java.nio.ByteBuffer Name, java.nio.ShortBuffer StringLengthPtr, java.nio.ShortBuffer TypePtr, java.nio.ShortBuffer SubTypePtr, PointerBuffer LengthPtr, java.nio.ShortBuffer PrecisionPtr, java.nio.ShortBuffer ScalePtr, java.nio.ShortBuffer NullablePtr)static shortSQLGetDiagField(short HandleType, long Handle, short RecNumber, short DiagIdentifier, java.nio.ByteBuffer DiagInfoPtr, java.nio.ShortBuffer StringLengthPtr)static shortSQLGetDiagRec(short HandleType, long Handle, short RecNumber, java.nio.ByteBuffer SQLState, java.nio.IntBuffer NativeErrorPtr, java.nio.ByteBuffer MessageText, java.nio.ShortBuffer TextLengthPtr)static shortSQLGetEnvAttr(long EnvironmentHandle, int Attribute, java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)static shortSQLGetFunctions(long ConnectionHandle, short FunctionId, java.nio.ShortBuffer SupportedPtr)static shortSQLGetInfo(long ConnectionHandle, short InfoType, java.nio.ByteBuffer InfoValuePtr, java.nio.ShortBuffer StringLengthPtr)static shortSQLGetInfo(long ConnectionHandle, short InfoType, java.nio.IntBuffer InfoValuePtr, java.nio.ShortBuffer StringLengthPtr)static shortSQLGetInfo(long ConnectionHandle, short InfoType, java.nio.ShortBuffer InfoValuePtr, java.nio.ShortBuffer StringLengthPtr)static shortSQLGetInfo(long ConnectionHandle, short InfoType, PointerBuffer InfoValuePtr, java.nio.ShortBuffer StringLengthPtr)static shortSQLGetStmtAttr(long StatementHandle, int Attribute, java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)static shortSQLGetTypeInfo(long StatementHandle, short DataType)static shortSQLMoreResults(long StatementHandle)static shortSQLNativeSql(long ConnectionHandle, java.lang.CharSequence InStatementText, java.nio.ByteBuffer OutStatementText, java.nio.IntBuffer TextLength2Ptr)static shortSQLNativeSql(long ConnectionHandle, java.nio.ByteBuffer InStatementText, java.nio.ByteBuffer OutStatementText, java.nio.IntBuffer TextLength2Ptr)static shortSQLNumParams(long StatementHandle, java.nio.ShortBuffer ParameterCountPtr)static shortSQLNumResultCols(long StatementHandle, java.nio.ShortBuffer ColumnCountPtr)static shortSQLParamData(long StatementHandle, PointerBuffer ValuePtrPtr)static shortSQLParamOptions(long hstmt, long crow, PointerBuffer pirow)static shortSQLPrepare(long StatementHandle, java.lang.CharSequence StatementText)static shortSQLPrepare(long StatementHandle, java.nio.ByteBuffer StatementText)static shortSQLPrimaryKeys(long hstmt, java.nio.ByteBuffer szCatalogName, java.nio.ByteBuffer szSchemaName, java.nio.ByteBuffer szTableName)static shortSQLProcedureColumns(long hstmt, java.nio.ByteBuffer szCatalogName, java.nio.ByteBuffer szSchemaName, java.nio.ByteBuffer szProcName, java.nio.ByteBuffer szColumnName)static shortSQLProcedures(long hstmt, java.nio.ByteBuffer szCatalogName, java.nio.ByteBuffer szSchemaName, java.nio.ByteBuffer szProcName)static shortSQLPutData(long StatementHandle, java.nio.ByteBuffer DataPtr)static shortSQLRowCount(long StatementHandle, PointerBuffer RowCountPtr)static shortSQLSetConnectAttr(long ConnectionHandle, int Attribute, java.nio.ByteBuffer Value)static shortSQLSetCursorName(long StatementHandle, java.nio.ByteBuffer CursorName)static shortSQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, java.nio.ByteBuffer ValuePtr)static shortSQLSetDescRec(long DescriptorHandle, short RecNumber, short Type, short SubType, long Length, short Precision, short Scale, java.nio.ByteBuffer DataPtr, PointerBuffer StringLengthPtr, PointerBuffer IndicatorPtr)static shortSQLSetEnvAttr(long EnvironmentHandle, int Attribute, java.nio.ByteBuffer Value)static shortSQLSetPos(long StatementHandle, long RowNumber, short Operation, short LockType)static shortSQLSetStmtAttr(long StatementHandle, int Attribute, java.nio.ByteBuffer Value)static shortSQLSpecialColumns(long StatementHandle, short IdentifierType, java.nio.ByteBuffer CatalogName, java.nio.ByteBuffer SchemaName, java.nio.ByteBuffer TableName, short Scope, short Nullable)static shortSQLStatistics(long StatementHandle, java.nio.ByteBuffer CatalogName, java.nio.ByteBuffer SchemaName, java.nio.ByteBuffer TableName, short Unique, short Reserved)static shortSQLTablePrivileges(long hstmt, java.nio.ByteBuffer szCatalogName, java.nio.ByteBuffer szSchemaName, java.nio.ByteBuffer szTableName)static shortSQLTables(long StatementHandle, java.nio.ByteBuffer CatalogName, java.nio.ByteBuffer SchemaName, java.nio.ByteBuffer TableName, java.nio.ByteBuffer TableType)static shortSQLTransact(long EnvironmentHandle, long ConnectionHandle, short CompletionType)
-
-
-
Field Detail
-
SQL_NULL_DATA, SQL_DATA_AT_EXEC
Special length/indicator values.
-
SQL_INVALID_HANDLE, SQL_ERROR, SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_NEED_DATA, SQL_NO_DATA, SQL_NO_DATA_FOUND, SQL_PARAM_DATA_AVAILABLE
Return values from functions.
-
SQL_NTS
Flag for null-terminated string.
-
SQL_MAX_MESSAGE_LENGTH
Maximum message length.
-
SQL_DATE_LEN, SQL_TIME_LEN, SQL_TIMESTAMP_LEN
Date/time length constants.
-
SQL_HANDLE_ENV, SQL_HANDLE_DBC, SQL_HANDLE_STMT, SQL_HANDLE_DESC, SQL_HANDLE_SENV
Handle type identifiers.
-
SQL_ATTR_OUTPUT_NTS, SQL_ATTR_ODBC_VERSION, SQL_ATTR_CONNECTION_POOLING, SQL_ATTR_CP_MATCH
Environment attributes.
-
SQL_ATTR_AUTO_IPD, SQL_ATTR_METADATA_ID, SQL_ATTR_ACCESS_MODE, SQL_ATTR_AUTOCOMMIT, SQL_ATTR_CONNECTION_TIMEOUT, SQL_ATTR_CURRENT_CATALOG, SQL_ATTR_DISCONNECT_BEHAVIOR, SQL_ATTR_ENLIST_IN_DTC, SQL_ATTR_ENLIST_IN_XA, SQL_ATTR_LOGIN_TIMEOUT, SQL_ATTR_ODBC_CURSORS, SQL_ATTR_PACKET_SIZE, SQL_ATTR_QUIET_MODE, SQL_ATTR_TRACE, SQL_ATTR_TRACEFILE, SQL_ATTR_TRANSLATE_LIB, SQL_ATTR_TRANSLATE_OPTION, SQL_ATTR_TXN_ISOLATION, SQL_ATTR_CONNECTION_DEAD, SQL_ATTR_ANSI_APP, SQL_ATTR_RESET_CONNECTION, SQL_ATTR_ASYNC_DBC_FUNCTIONS_ENABLE, SQL_ATTR_ASYNC_DBC_EVENT
Connection attributes.
-
SQL_ATTR_APP_ROW_DESC, SQL_ATTR_APP_PARAM_DESC, SQL_ATTR_IMP_ROW_DESC, SQL_ATTR_IMP_PARAM_DESC, SQL_ATTR_CURSOR_SCROLLABLE, SQL_ATTR_CURSOR_SENSITIVITY, SQL_ATTR_ASYNC_ENABLE, SQL_ATTR_CONCURRENCY, SQL_ATTR_CURSOR_TYPE, SQL_ATTR_ENABLE_AUTO_IPD, SQL_ATTR_FETCH_BOOKMARK_PTR, SQL_ATTR_KEYSET_SIZE, SQL_ATTR_MAX_LENGTH, SQL_ATTR_MAX_ROWS, SQL_ATTR_NOSCAN, SQL_ATTR_PARAM_BIND_OFFSET_PTR, SQL_ATTR_PARAM_BIND_TYPE, SQL_ATTR_PARAM_OPERATION_PTR, SQL_ATTR_PARAM_STATUS_PTR, SQL_ATTR_PARAMS_PROCESSED_PTR, SQL_ATTR_PARAMSET_SIZE, SQL_ATTR_QUERY_TIMEOUT, SQL_ATTR_RETRIEVE_DATA, SQL_ATTR_ROW_BIND_OFFSET_PTR, SQL_ATTR_ROW_BIND_TYPE, SQL_ATTR_ROW_NUMBER, SQL_ATTR_ROW_OPERATION_PTR, SQL_ATTR_ROW_STATUS_PTR, SQL_ATTR_ROWS_FETCHED_PTR, SQL_ATTR_ROW_ARRAY_SIZE, SQL_ATTR_SIMULATE_CURSOR, SQL_ATTR_USE_BOOKMARKS, SQL_ATTR_ASYNC_STMT_EVENT
Statement attributes.
-
SQL_DESC_COUNT, SQL_DESC_TYPE, SQL_DESC_LENGTH, SQL_DESC_OCTET_LENGTH_PTR, SQL_DESC_PRECISION, SQL_DESC_SCALE, SQL_DESC_DATETIME_INTERVAL_CODE, SQL_DESC_NULLABLE, SQL_DESC_INDICATOR_PTR, SQL_DESC_DATA_PTR, SQL_DESC_NAME, SQL_DESC_UNNAMED, SQL_DESC_OCTET_LENGTH, SQL_DESC_ALLOC_TYPE
Identifiers of fields in the SQL descriptor.
-
SQL_DIAG_RETURNCODE, SQL_DIAG_NUMBER, SQL_DIAG_ROW_COUNT, SQL_DIAG_SQLSTATE, SQL_DIAG_NATIVE, SQL_DIAG_MESSAGE_TEXT, SQL_DIAG_DYNAMIC_FUNCTION, SQL_DIAG_CLASS_ORIGIN, SQL_DIAG_SUBCLASS_ORIGIN, SQL_DIAG_CONNECTION_NAME, SQL_DIAG_SERVER_NAME, SQL_DIAG_DYNAMIC_FUNCTION_CODE
Identifiers of fields in the diagnostics area.
-
SQL_DIAG_ALTER_DOMAIN, SQL_DIAG_ALTER_TABLE, SQL_DIAG_CALL, SQL_DIAG_CREATE_ASSERTION, SQL_DIAG_CREATE_CHARACTER_SET, SQL_DIAG_CREATE_COLLATION, SQL_DIAG_CREATE_DOMAIN, SQL_DIAG_CREATE_INDEX, SQL_DIAG_CREATE_SCHEMA, SQL_DIAG_CREATE_TABLE, SQL_DIAG_CREATE_TRANSLATION, SQL_DIAG_CREATE_VIEW, SQL_DIAG_DELETE_WHERE, SQL_DIAG_DROP_ASSERTION, SQL_DIAG_DROP_CHARACTER_SET, SQL_DIAG_DROP_COLLATION, SQL_DIAG_DROP_DOMAIN, SQL_DIAG_DROP_INDEX, SQL_DIAG_DROP_SCHEMA, SQL_DIAG_DROP_TABLE, SQL_DIAG_DROP_TRANSLATION, SQL_DIAG_DROP_VIEW, SQL_DIAG_DYNAMIC_DELETE_CURSOR, SQL_DIAG_DYNAMIC_UPDATE_CURSOR, SQL_DIAG_GRANT, SQL_DIAG_INSERT, SQL_DIAG_REVOKE, SQL_DIAG_SELECT_CURSOR, SQL_DIAG_UNKNOWN_STATEMENT, SQL_DIAG_UPDATE_WHERE
Dynamic function codes.
-
SQL_UNKNOWN_TYPE, SQL_CHAR, SQL_NUMERIC, SQL_DECIMAL, SQL_INTEGER, SQL_SMALLINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATETIME, SQL_VARCHAR
SQL data type codes.
-
SQL_UNSPECIFIED, SQL_INSENSITIVE, SQL_SENSITIVE
Statement attribute values for cursor sensitivity.
-
SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP
One-parameter shortcuts for date/time data types.
-
SQL_ALL_TYPES
GetTypeInfo() request for all data types.
-
SQL_ARD_TYPE, SQL_APD_TYPE
SQLSQLLENGetDatacode indicating that the application row descriptor specifies the data type.
-
SQL_CODE_DATE, SQL_CODE_TIME, SQL_CODE_TIMESTAMP
SQL date/time type subcodes.
-
SQL_NO_NULLS, SQL_NULLABLE
Values ofDESC_NULLABLEfield in descriptor.
-
SQL_NULLABLE_UNKNOWN
Value returned byGetTypeInfoto denote that it is not known whether or not a data type supports null values.
-
SQL_PRED_NONE, SQL_PRED_CHAR, SQL_PRED_BASIC
Values returned byGetTypeInfoto show WHERE clause supported.
-
SQL_NAMED, SQL_UNNAMED
Values ofDESC_UNNAMEDfield in descriptor.
-
SQL_DESC_ALLOC_AUTO, SQL_DESC_ALLOC_USER
Values ofDESC_ALLOC_TYPEfield in descriptor.
-
SQL_CLOSE, SQL_DROP, SQL_UNBIND, SQL_RESET_PARAMS
FreeStmtoptions.
-
SQL_FETCH_LAST, SQL_FETCH_PRIOR, SQL_FETCH_ABSOLUTE, SQL_FETCH_RELATIVE
Other codes used forFetchOrientationinFetchScroll.
-
SQL_COMMIT, SQL_ROLLBACK
EndTranoptions.
-
SQL_NULL_HENV, SQL_NULL_HDBC, SQL_NULL_HSTMT, SQL_NULL_HDESC, SQL_NULL_HANDLE
Null handles return byAllocHandle.
-
SQL_SCOPE_CURROW, SQL_SCOPE_TRANSACTION, SQL_SCOPE_SESSION, SQL_PC_UNKNOWN, SQL_PC_NON_PSEUDO, SQL_PC_PSEUDO
Values that may appear in the result set ofSpecialColumns.
-
SQL_ROW_IDENTIFIER
Reserved value for theIdentifierTypeargument ofSpecialColumns.
-
SQL_INDEX_UNIQUE, SQL_INDEX_ALL
Reserved values for UNIQUE argument ofStatistics.
-
SQL_INDEX_CLUSTERED, SQL_INDEX_HASHED, SQL_INDEX_OTHER
Values that may appear in the result set ofStatistics.
-
SQL_API_SQLALLOCCONNECT, SQL_API_SQLALLOCENV, SQL_API_SQLALLOCHANDLE, SQL_API_SQLALLOCSTMT, SQL_API_SQLBINDCOL, SQL_API_SQLBINDPARAM, SQL_API_SQLCANCEL, SQL_API_SQLCLOSECURSOR, SQL_API_SQLCOLATTRIBUTE, SQL_API_SQLCOLUMNS, SQL_API_SQLCONNECT, SQL_API_SQLCOPYDESC, SQL_API_SQLDATASOURCES, SQL_API_SQLDESCRIBECOL, SQL_API_SQLDISCONNECT, SQL_API_SQLENDTRAN, SQL_API_SQLERROR, SQL_API_SQLEXECDIRECT, SQL_API_SQLEXECUTE, SQL_API_SQLFETCH, SQL_API_SQLFETCHSCROLL, SQL_API_SQLFREECONNECT, SQL_API_SQLFREEENV, SQL_API_SQLFREEHANDLE, SQL_API_SQLFREESTMT, SQL_API_SQLGETCONNECTATTR, SQL_API_SQLGETCONNECTOPTION, SQL_API_SQLGETCURSORNAME, SQL_API_SQLGETDATA, SQL_API_SQLGETDESCFIELD, SQL_API_SQLGETDESCREC, SQL_API_SQLGETDIAGFIELD, SQL_API_SQLGETDIAGREC, SQL_API_SQLGETENVATTR, SQL_API_SQLGETFUNCTIONS, SQL_API_SQLGETINFO, SQL_API_SQLGETSTMTATTR, SQL_API_SQLGETSTMTOPTION, SQL_API_SQLGETTYPEINFO, SQL_API_SQLNUMRESULTCOLS, SQL_API_SQLPARAMDATA, SQL_API_SQLPREPARE, SQL_API_SQLPUTDATA, SQL_API_SQLROWCOUNT, SQL_API_SQLSETCONNECTATTR, SQL_API_SQLSETCONNECTOPTION, SQL_API_SQLSETCURSORNAME, SQL_API_SQLSETDESCFIELD, SQL_API_SQLSETDESCREC, SQL_API_SQLSETENVATTR, SQL_API_SQLSETPARAM, SQL_API_SQLSETSTMTATTR, SQL_API_SQLSETSTMTOPTION, SQL_API_SQLSPECIALCOLUMNS, SQL_API_SQLSTATISTICS, SQL_API_SQLTABLES, SQL_API_SQLTRANSACT, SQL_API_SQLCANCELHANDLE, SQL_API_SQLCOMPLETEASYNC, SQL_API_SQLALLOCHANDLESTD, SQL_API_SQLBULKOPERATIONS, SQL_API_SQLBINDPARAMETER, SQL_API_SQLBROWSECONNECT, SQL_API_SQLCOLATTRIBUTES, SQL_API_SQLCOLUMNPRIVILEGES, SQL_API_SQLDESCRIBEPARAM, SQL_API_SQLDRIVERCONNECT, SQL_API_SQLDRIVERS, SQL_API_SQLEXTENDEDFETCH, SQL_API_SQLFOREIGNKEYS, SQL_API_SQLMORERESULTS, SQL_API_SQLNATIVESQL, SQL_API_SQLNUMPARAMS, SQL_API_SQLPARAMOPTIONS, SQL_API_SQLPRIMARYKEYS, SQL_API_SQLPROCEDURECOLUMNS, SQL_API_SQLPROCEDURES, SQL_API_SQLSETPOS, SQL_API_SQLSETSCROLLOPTIONS, SQL_API_SQLTABLEPRIVILEGES
GetFunctionsvalues to identify ODBC APIs.
-
SQL_API_ODBC3_ALL_FUNCTIONS, SQL_API_ODBC3_ALL_FUNCTIONS_SIZE
This returns a bitmap, which allows us to handle the higher-valued function numbers. Use SQL_FUNC_EXISTS(bitmap,function_number) to determine if the function exists.
-
SQL_MAX_DRIVER_CONNECTIONS, SQL_MAXIMUM_DRIVER_CONNECTIONS, SQL_MAX_CONCURRENT_ACTIVITIES, SQL_MAXIMUM_CONCURRENT_ACTIVITIES, SQL_DATA_SOURCE_NAME, SQL_FETCH_DIRECTION, SQL_SERVER_NAME, SQL_SEARCH_PATTERN_ESCAPE, SQL_DBMS_NAME, SQL_DBMS_VER, SQL_ACCESSIBLE_TABLES, SQL_ACCESSIBLE_PROCEDURES, SQL_CURSOR_COMMIT_BEHAVIOR, SQL_DATA_SOURCE_READ_ONLY, SQL_DEFAULT_TXN_ISOLATION, SQL_IDENTIFIER_CASE, SQL_IDENTIFIER_QUOTE_CHAR, SQL_MAX_COLUMN_NAME_LEN, SQL_MAXIMUM_COLUMN_NAME_LENGTH, SQL_MAX_CURSOR_NAME_LEN, SQL_MAXIMUM_CURSOR_NAME_LENGTH, SQL_MAX_SCHEMA_NAME_LEN, SQL_MAXIMUM_SCHEMA_NAME_LENGTH, SQL_MAX_CATALOG_NAME_LEN, SQL_MAXIMUM_CATALOG_NAME_LENGTH, SQL_MAX_TABLE_NAME_LEN, SQL_SCROLL_CONCURRENCY, SQL_TXN_CAPABLE, SQL_TRANSACTION_CAPABLE, SQL_USER_NAME, SQL_TXN_ISOLATION_OPTION, SQL_TRANSACTION_ISOLATION_OPTION, SQL_INTEGRITY, SQL_GETDATA_EXTENSIONS, SQL_NULL_COLLATION, SQL_ALTER_TABLE, SQL_ORDER_BY_COLUMNS_IN_SELECT, SQL_SPECIAL_CHARACTERS, SQL_MAX_COLUMNS_IN_GROUP_BY, SQL_MAXIMUM_COLUMNS_IN_GROUP_BY, SQL_MAX_COLUMNS_IN_INDEX, SQL_MAXIMUM_COLUMNS_IN_INDEX, SQL_MAX_COLUMNS_IN_ORDER_BY, SQL_MAXIMUM_COLUMNS_IN_ORDER_BY, SQL_MAX_COLUMNS_IN_SELECT, SQL_MAXIMUM_COLUMNS_IN_SELECT, SQL_MAX_COLUMNS_IN_TABLE, SQL_MAX_INDEX_SIZE, SQL_MAXIMUM_INDEX_SIZE, SQL_MAX_ROW_SIZE, SQL_MAXIMUM_ROW_SIZE, SQL_MAX_STATEMENT_LEN, SQL_MAXIMUM_STATEMENT_LENGTH, SQL_MAX_TABLES_IN_SELECT, SQL_MAXIMUM_TABLES_IN_SELECT, SQL_MAX_USER_NAME_LEN, SQL_MAXIMUM_USER_NAME_LENGTH, SQL_OJ_CAPABILITIES, SQL_OUTER_JOIN_CAPABILITIES, SQL_XOPEN_CLI_YEAR, SQL_CURSOR_SENSITIVITY, SQL_DESCRIBE_PARAMETER, SQL_CATALOG_NAME, SQL_COLLATION_SEQ, SQL_MAX_IDENTIFIER_LEN, SQL_MAXIMUM_IDENTIFIER_LENGTH
Information requested byGetInfo:
-
SQL_AT_ADD_COLUMN, SQL_AT_DROP_COLUMN, SQL_AT_ADD_CONSTRAINT, SQL_AT_ADD_COLUMN_SINGLE, SQL_AT_ADD_COLUMN_DEFAULT, SQL_AT_ADD_COLUMN_COLLATION, SQL_AT_SET_COLUMN_DEFAULT, SQL_AT_DROP_COLUMN_DEFAULT, SQL_AT_DROP_COLUMN_CASCADE, SQL_AT_DROP_COLUMN_RESTRICT, SQL_AT_ADD_TABLE_CONSTRAINT, SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE, SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT, SQL_AT_CONSTRAINT_NAME_DEFINITION, SQL_AT_CONSTRAINT_INITIALLY_DEFERRED, SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE, SQL_AT_CONSTRAINT_DEFERRABLE, SQL_AT_CONSTRAINT_NON_DEFERRABLE
ALTER_TABLEbitmasks.
-
SQL_FD_FETCH_NEXT, SQL_FD_FETCH_FIRST, SQL_FD_FETCH_LAST, SQL_FD_FETCH_PRIOR, SQL_FD_FETCH_ABSOLUTE, SQL_FD_FETCH_RELATIVE
FETCH_DIRECTIONbitmasks.
-
SQL_GD_ANY_COLUMN, SQL_GD_ANY_ORDER
GETDATA_EXTENSIONSbitmasks.
-
SQL_OJ_LEFT, SQL_OJ_RIGHT, SQL_OJ_FULL, SQL_OJ_NESTED, SQL_OJ_NOT_ORDERED, SQL_OJ_INNER, SQL_OJ_ALL_COMPARISON_OPS
OJ_CAPABILITIESbitmasks.
-
SQL_SCCO_READ_ONLY, SQL_SCCO_LOCK, SQL_SCCO_OPT_ROWVER, SQL_SCCO_OPT_VALUES
SCROLL_CONCURRENCYbitmasks.
-
SQL_TRANSACTION_READ_UNCOMMITTED, SQL_TRANSACTION_READ_COMMITTED, SQL_TRANSACTION_REPEATABLE_READ, SQL_TRANSACTION_SERIALIZABLE
TXN_ISOLATION_OPTIONbitmasks.
-
SQL_NC_HIGH, SQL_NC_LOW
NULL_COLLATIONvalues.
-
SQL_SPEC_MAJOR, SQL_SPEC_MINOR, SQL_SQLSTATE_SIZE, SQL_MAX_DSN_LENGTH, SQL_MAX_OPTION_STRING_LENGTH
Generally useful constants.
-
SQL_CP_OFF, SQL_CP_ONE_PER_DRIVER, SQL_CP_ONE_PER_HENV, SQL_CP_DRIVER_AWARE, SQL_CP_DEFAULT
Values forATTR_CONNECTION_POOLING.
-
SQL_OV_ODBC2, SQL_OV_ODBC3, SQL_OV_ODBC3_80
Values forATTR_ODBC_VERSION.
-
SQL_OPT_TRACE_OFF, SQL_OPT_TRACE_ON, SQL_OPT_TRACE_DEFAULT, SQL_OPT_TRACE_FILE_DEFAULT
ATTR_TRACEoptions
-
SQL_CUR_USE_IF_NEEDED, SQL_CUR_USE_ODBC, SQL_CUR_USE_DRIVER, SQL_CUR_DEFAULT
ATTR_ODBC_CURSORSoptions
-
SQL_DTC_DONE
Values forATTR_ENLIST_IN_DTC.
-
SQL_CD_TRUE, SQL_CD_FALSE
Values forATTR_CONNECTION_DEAD.
-
SQL_AA_TRUE, SQL_AA_FALSE
Values forATTR_ANSI_APP.
-
SQL_RESET_CONNECTION_YES
Values forATTR_RESET_CONNECTION.
-
SQL_ASYNC_DBC_ENABLE_ON, SQL_ASYNC_DBC_ENABLE_OFF, SQL_ASYNC_DBC_ENABLE_DEFAULT
Values forATTR_ASYNC_DBC_FUNCTIONS_ENABLE.
-
SQL_IS_POINTER, SQL_IS_UINTEGER, SQL_IS_INTEGER, SQL_IS_USMALLINT, SQL_IS_SMALLINT
Attribute types.
-
SQL_MAX_ROWS_DEFAULT
ATTR_MAX_ROWSoptions.
-
SQL_NOSCAN_OFF, SQL_NOSCAN_ON, SQL_NOSCAN_DEFAULT
ATTR_NOSCANoptions.
-
SQL_MAX_LENGTH_DEFAULT
ATTR_MAX_LENGTHoptions.
-
SQL_CONCUR_READ_ONLY, SQL_CONCUR_LOCK, SQL_CONCUR_ROWVER, SQL_CONCUR_VALUES, SQL_CONCUR_DEFAULT
ATTR_CONCURRENCYoptions.
-
SQL_CURSOR_FORWARD_ONLY, SQL_CURSOR_KEYSET_DRIVEN, SQL_CURSOR_DYNAMIC, SQL_CURSOR_STATIC, SQL_CURSOR_TYPE_DEFAULT
ATTR_CURSOR_TYPEoptions.
-
SQL_KEYSET_SIZE_DEFAULT
ATTR_KEYSET_SIZEoptions.
-
SQL_RD_OFF, SQL_RD_ON, SQL_RD_DEFAULT
ATTR_RETRIEVE_DATAoptions.
-
SQL_COLUMN_COUNT, SQL_COLUMN_NAME, SQL_COLUMN_TYPE, SQL_COLUMN_LENGTH, SQL_COLUMN_PRECISION, SQL_COLUMN_SCALE, SQL_COLUMN_DISPLAY_SIZE, SQL_COLUMN_NULLABLE, SQL_COLUMN_UNSIGNED, SQL_COLUMN_MONEY, SQL_COLUMN_UPDATABLE, SQL_COLUMN_AUTO_INCREMENT, SQL_COLUMN_CASE_SENSITIVE, SQL_COLUMN_SEARCHABLE, SQL_COLUMN_TYPE_NAME, SQL_COLUMN_TABLE_NAME, SQL_COLUMN_OWNER_NAME, SQL_COLUMN_QUALIFIER_NAME, SQL_COLUMN_LABEL, SQL_COLATT_OPT_MAX, SQL_COLATT_OPT_MIN
ColAttributedefines.
-
SQL_DESC_ARRAY_SIZE, SQL_DESC_ARRAY_STATUS_PTR, SQL_DESC_AUTO_UNIQUE_VALUE, SQL_DESC_BASE_COLUMN_NAME, SQL_DESC_BASE_TABLE_NAME, SQL_DESC_BIND_OFFSET_PTR, SQL_DESC_BIND_TYPE, SQL_DESC_CASE_SENSITIVE, SQL_DESC_CATALOG_NAME, SQL_DESC_CONCISE_TYPE, SQL_DESC_DATETIME_INTERVAL_PRECISION, SQL_DESC_DISPLAY_SIZE, SQL_DESC_FIXED_PREC_SCALE, SQL_DESC_LABEL, SQL_DESC_LITERAL_PREFIX, SQL_DESC_LITERAL_SUFFIX, SQL_DESC_LOCAL_TYPE_NAME, SQL_DESC_MAXIMUM_SCALE, SQL_DESC_MINIMUM_SCALE, SQL_DESC_NUM_PREC_RADIX, SQL_DESC_PARAMETER_TYPE, SQL_DESC_ROWS_PROCESSED_PTR, SQL_DESC_ROWVER, SQL_DESC_SCHEMA_NAME, SQL_DESC_SEARCHABLE, SQL_DESC_TYPE_NAME, SQL_DESC_TABLE_NAME, SQL_DESC_UNSIGNED, SQL_DESC_UPDATABLE
Extended descriptor field.
-
SQL_DIAG_CURSOR_ROW_COUNT, SQL_DIAG_ROW_NUMBER, SQL_DIAG_COLUMN_NUMBER
Defines for diagnostics fields.
-
SQL_DATE, SQL_INTERVAL, SQL_TIME, SQL_TIMESTAMP, SQL_LONGVARCHAR, SQL_BINARY, SQL_VARBINARY, SQL_LONGVARBINARY, SQL_BIGINT, SQL_TINYINT, SQL_BIT, SQL_GUID
SQL extended datatypes.
-
SQL_CODE_YEAR, SQL_CODE_MONTH, SQL_CODE_DAY, SQL_CODE_HOUR, SQL_CODE_MINUTE, SQL_CODE_SECOND, SQL_CODE_YEAR_TO_MONTH, SQL_CODE_DAY_TO_HOUR, SQL_CODE_DAY_TO_MINUTE, SQL_CODE_DAY_TO_SECOND, SQL_CODE_HOUR_TO_MINUTE, SQL_CODE_HOUR_TO_SECOND, SQL_CODE_MINUTE_TO_SECOND, SQL_INTERVAL_YEAR, SQL_INTERVAL_MONTH, SQL_INTERVAL_DAY, SQL_INTERVAL_HOUR, SQL_INTERVAL_MINUTE, SQL_INTERVAL_SECOND, SQL_INTERVAL_YEAR_TO_MONTH, SQL_INTERVAL_DAY_TO_HOUR, SQL_INTERVAL_DAY_TO_MINUTE, SQL_INTERVAL_DAY_TO_SECOND, SQL_INTERVAL_HOUR_TO_MINUTE, SQL_INTERVAL_HOUR_TO_SECOND, SQL_INTERVAL_MINUTE_TO_SECOND
Interval code.
-
SQL_WCHAR, SQL_WVARCHAR, SQL_WLONGVARCHAR, SQL_C_WCHAR
WCHAR definitions.
-
SQL_UNICODE, SQL_UNICODE_VARCHAR, SQL_UNICODE_LONGVARCHAR, SQL_UNICODE_CHAR
UNICODE definitions.
-
SQL_SIGNED_OFFSET, SQL_UNSIGNED_OFFSET
Sign offsets.
-
SQL_C_CHAR, SQL_C_LONG, SQL_C_SHORT, SQL_C_FLOAT, SQL_C_DOUBLE, SQL_C_NUMERIC, SQL_C_DEFAULT, SQL_C_DATE, SQL_C_TIME, SQL_C_TIMESTAMP, SQL_C_TYPE_DATE, SQL_C_TYPE_TIME, SQL_C_TYPE_TIMESTAMP, SQL_C_INTERVAL_YEAR, SQL_C_INTERVAL_MONTH, SQL_C_INTERVAL_DAY, SQL_C_INTERVAL_HOUR, SQL_C_INTERVAL_MINUTE, SQL_C_INTERVAL_SECOND, SQL_C_INTERVAL_YEAR_TO_MONTH, SQL_C_INTERVAL_DAY_TO_HOUR, SQL_C_INTERVAL_DAY_TO_MINUTE, SQL_C_INTERVAL_DAY_TO_SECOND, SQL_C_INTERVAL_HOUR_TO_MINUTE, SQL_C_INTERVAL_HOUR_TO_SECOND, SQL_C_INTERVAL_MINUTE_TO_SECOND, SQL_C_BINARY, SQL_C_BIT, SQL_C_SBIGINT, SQL_C_UBIGINT, SQL_C_TINYINT, SQL_C_SLONG, SQL_C_SSHORT, SQL_C_STINYINT, SQL_C_ULONG, SQL_C_USHORT, SQL_C_UTINYINT, SQL_C_BOOKMARK, SQL_C_GUID, SQL_C_VARBOOKMARK
C datatype to SQL datatype mapping.
-
SQL_TYPE_NULL
NULL type.
-
SQL_DRIVER_C_TYPE_BASE
Base value of driver-specific C-Type (max is 0x7fff) define driver-specific C-Type, named as SQL_DRIVER_C_TYPE_BASE, SQL_DRIVER_C_TYPE_BASE+1, SQL_DRIVER_C_TYPE_BASE+2, etc.
-
SQL_DRIVER_SQL_TYPE_BASE, SQL_DRIVER_DESC_FIELD_BASE, SQL_DRIVER_DIAG_FIELD_BASE, SQL_DRIVER_INFO_TYPE_BASE
Base value of driver-specific fields/attributes (max are 0x7fff [16-bit] or 0x00007fff [32-bit]) define driver-specific SQL-Type, named as SQL_DRIVER_SQL_TYPE_BASE, SQL_DRIVER_SQL_TYPE_BASE+1, SQL_DRIVER_SQL_TYPE_BASE+2, etc..
-
SQL_NO_ROW_NUMBER, SQL_NO_COLUMN_NUMBER, SQL_ROW_NUMBER_UNKNOWN, SQL_COLUMN_NUMBER_UNKNOWN
Define forDIAG_ROW_NUMBERandDIAG_COLUMN_NUMBER.
-
SQL_DEFAULT_PARAM, SQL_IGNORE, SQL_COLUMN_IGNORE, SQL_LEN_DATA_AT_EXEC_OFFSET
BindParameterextensions.
-
SQL_LEN_BINARY_ATTR_OFFSET
Binary length for driver specific attributes.
-
SQL_PARAM_TYPE_UNKNOWN, SQL_PARAM_INPUT, SQL_PARAM_INPUT_OUTPUT, SQL_RESULT_COL, SQL_PARAM_OUTPUT, SQL_RETURN_VALUE, SQL_PARAM_INPUT_OUTPUT_STREAM, SQL_PARAM_OUTPUT_STREAM
Defines forBindParameterandProcedureColumns(returned in the result set).
-
SQL_PARAM_TYPE_DEFAULT, SQL_SETPARAM_VALUE_MAX
Defines used by Driver Manager when mappingSetParamtoBindParameter.
-
SQL_ATTR_READONLY, SQL_ATTR_WRITE, SQL_ATTR_READWRITE_UNKNOWN
ColAttributesubdefines forCOLUMN_UPDATABLE.
-
SQL_COL_PRED_CHAR, SQL_COL_PRED_BASIC
New defines for SEARCHABLE column inGetTypeInfo.
-
SQL_NO_TOTAL
Special return values forGetData.
-
SQL_INFO_FIRST, SQL_ACTIVE_CONNECTIONS, SQL_ACTIVE_STATEMENTS, SQL_DRIVER_HDBC, SQL_DRIVER_HENV, SQL_DRIVER_HSTMT, SQL_DRIVER_NAME, SQL_DRIVER_VER, SQL_ODBC_API_CONFORMANCE, SQL_ODBC_VER, SQL_ROW_UPDATES, SQL_ODBC_SAG_CLI_CONFORMANCE, SQL_ODBC_SQL_CONFORMANCE, SQL_PROCEDURES, SQL_CONCAT_NULL_BEHAVIOR, SQL_CURSOR_ROLLBACK_BEHAVIOR, SQL_EXPRESSIONS_IN_ORDERBY, SQL_MAX_OWNER_NAME_LEN, SQL_MAX_PROCEDURE_NAME_LEN, SQL_MAX_QUALIFIER_NAME_LEN, SQL_MULT_RESULT_SETS, SQL_MULTIPLE_ACTIVE_TXN, SQL_OUTER_JOINS, SQL_OWNER_TERM, SQL_PROCEDURE_TERM, SQL_QUALIFIER_NAME_SEPARATOR, SQL_QUALIFIER_TERM, SQL_SCROLL_OPTIONS, SQL_TABLE_TERM, SQL_CONVERT_FUNCTIONS, SQL_NUMERIC_FUNCTIONS, SQL_STRING_FUNCTIONS, SQL_SYSTEM_FUNCTIONS, SQL_TIMEDATE_FUNCTIONS, SQL_CONVERT_BIGINT, SQL_CONVERT_BINARY, SQL_CONVERT_BIT, SQL_CONVERT_CHAR, SQL_CONVERT_DATE, SQL_CONVERT_DECIMAL, SQL_CONVERT_DOUBLE, SQL_CONVERT_FLOAT, SQL_CONVERT_INTEGER, SQL_CONVERT_LONGVARCHAR, SQL_CONVERT_NUMERIC, SQL_CONVERT_REAL, SQL_CONVERT_SMALLINT, SQL_CONVERT_TIME, SQL_CONVERT_TIMESTAMP, SQL_CONVERT_TINYINT, SQL_CONVERT_VARBINARY, SQL_CONVERT_VARCHAR, SQL_CONVERT_LONGVARBINARY, SQL_ODBC_SQL_OPT_IEF, SQL_CORRELATION_NAME, SQL_NON_NULLABLE_COLUMNS, SQL_DRIVER_HLIB, SQL_DRIVER_ODBC_VER, SQL_LOCK_TYPES, SQL_POS_OPERATIONS, SQL_POSITIONED_STATEMENTS, SQL_BOOKMARK_PERSISTENCE, SQL_STATIC_SENSITIVITY, SQL_FILE_USAGE, SQL_COLUMN_ALIAS, SQL_GROUP_BY, SQL_KEYWORDS, SQL_OWNER_USAGE, SQL_QUALIFIER_USAGE, SQL_QUOTED_IDENTIFIER_CASE, SQL_SUBQUERIES, SQL_UNION, SQL_MAX_ROW_SIZE_INCLUDES_LONG, SQL_MAX_CHAR_LITERAL_LEN, SQL_TIMEDATE_ADD_INTERVALS, SQL_TIMEDATE_DIFF_INTERVALS, SQL_NEED_LONG_DATA_LEN, SQL_MAX_BINARY_LITERAL_LEN, SQL_LIKE_ESCAPE_CLAUSE, SQL_QUALIFIER_LOCATION, SQL_ACTIVE_ENVIRONMENTS, SQL_ALTER_DOMAIN, SQL_SQL_CONFORMANCE, SQL_DATETIME_LITERALS, SQL_ASYNC_MODE, SQL_BATCH_ROW_COUNT, SQL_BATCH_SUPPORT, SQL_CATALOG_LOCATION, SQL_CATALOG_NAME_SEPARATOR, SQL_CATALOG_TERM, SQL_CATALOG_USAGE, SQL_CONVERT_WCHAR, SQL_CONVERT_INTERVAL_DAY_TIME, SQL_CONVERT_INTERVAL_YEAR_MONTH, SQL_CONVERT_WLONGVARCHAR, SQL_CONVERT_WVARCHAR, SQL_CREATE_ASSERTION, SQL_CREATE_CHARACTER_SET, SQL_CREATE_COLLATION, SQL_CREATE_DOMAIN, SQL_CREATE_SCHEMA, SQL_CREATE_TABLE, SQL_CREATE_TRANSLATION, SQL_CREATE_VIEW, SQL_DRIVER_HDESC, SQL_DROP_ASSERTION, SQL_DROP_CHARACTER_SET, SQL_DROP_COLLATION, SQL_DROP_DOMAIN, SQL_DROP_SCHEMA, SQL_DROP_TABLE, SQL_DROP_TRANSLATION, SQL_DROP_VIEW, SQL_DYNAMIC_CURSOR_ATTRIBUTES1, SQL_DYNAMIC_CURSOR_ATTRIBUTES2, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2, SQL_INDEX_KEYWORDS, SQL_INFO_SCHEMA_VIEWS, SQL_KEYSET_CURSOR_ATTRIBUTES1, SQL_KEYSET_CURSOR_ATTRIBUTES2, SQL_MAX_ASYNC_CONCURRENT_STATEMENTS, SQL_ODBC_INTERFACE_CONFORMANCE, SQL_PARAM_ARRAY_ROW_COUNTS, SQL_PARAM_ARRAY_SELECTS, SQL_SCHEMA_TERM, SQL_SCHEMA_USAGE, SQL_SQL92_DATETIME_FUNCTIONS, SQL_SQL92_FOREIGN_KEY_DELETE_RULE, SQL_SQL92_FOREIGN_KEY_UPDATE_RULE, SQL_SQL92_GRANT, SQL_SQL92_NUMERIC_VALUE_FUNCTIONS, SQL_SQL92_PREDICATES, SQL_SQL92_RELATIONAL_JOIN_OPERATORS, SQL_SQL92_REVOKE, SQL_SQL92_ROW_VALUE_CONSTRUCTOR, SQL_SQL92_STRING_FUNCTIONS, SQL_SQL92_VALUE_EXPRESSIONS, SQL_STANDARD_CLI_CONFORMANCE, SQL_STATIC_CURSOR_ATTRIBUTES1, SQL_STATIC_CURSOR_ATTRIBUTES2, SQL_AGGREGATE_FUNCTIONS, SQL_DDL_INDEX, SQL_DM_VER, SQL_INSERT_STATEMENT, SQL_CONVERT_GUID, SQL_UNION_STATEMENT, SQL_ASYNC_DBC_FUNCTIONS, SQL_DRIVER_AWARE_POOLING_SUPPORTED, SQL_ASYNC_NOTIFICATION
Info types forGetInfo.
-
SQL_ASYNC_NOTIFICATION_NOT_CAPABLE, SQL_ASYNC_NOTIFICATION_CAPABLE
Possible values forASYNC_NOTIFICATION.
-
SQL_CVT_CHAR, SQL_CVT_NUMERIC, SQL_CVT_DECIMAL, SQL_CVT_INTEGER, SQL_CVT_SMALLINT, SQL_CVT_FLOAT, SQL_CVT_REAL, SQL_CVT_DOUBLE, SQL_CVT_VARCHAR, SQL_CVT_LONGVARCHAR, SQL_CVT_BINARY, SQL_CVT_VARBINARY, SQL_CVT_BIT, SQL_CVT_TINYINT, SQL_CVT_BIGINT, SQL_CVT_DATE, SQL_CVT_TIME, SQL_CVT_TIMESTAMP, SQL_CVT_LONGVARBINARY, SQL_CVT_INTERVAL_YEAR_MONTH, SQL_CVT_INTERVAL_DAY_TIME, SQL_CVT_WCHAR, SQL_CVT_WLONGVARCHAR, SQL_CVT_WVARCHAR, SQL_CVT_GUID
SQL_CONVERT_ return value bitmasks.
-
SQL_FN_CVT_CONVERT, SQL_FN_CVT_CAST
CONVERT_FUNCTIONSfunctions.
-
SQL_FN_STR_CONCAT, SQL_FN_STR_INSERT, SQL_FN_STR_LEFT, SQL_FN_STR_LTRIM, SQL_FN_STR_LENGTH, SQL_FN_STR_LOCATE, SQL_FN_STR_LCASE, SQL_FN_STR_REPEAT, SQL_FN_STR_REPLACE, SQL_FN_STR_RIGHT, SQL_FN_STR_RTRIM, SQL_FN_STR_SUBSTRING, SQL_FN_STR_UCASE, SQL_FN_STR_ASCII, SQL_FN_STR_CHAR, SQL_FN_STR_DIFFERENCE, SQL_FN_STR_LOCATE_2, SQL_FN_STR_SOUNDEX, SQL_FN_STR_SPACE, SQL_FN_STR_BIT_LENGTH, SQL_FN_STR_CHAR_LENGTH, SQL_FN_STR_CHARACTER_LENGTH, SQL_FN_STR_OCTET_LENGTH, SQL_FN_STR_POSITION
STRING_FUNCTIONSfunctions.
-
SQL_SSF_CONVERT, SQL_SSF_LOWER, SQL_SSF_UPPER, SQL_SSF_SUBSTRING, SQL_SSF_TRANSLATE, SQL_SSF_TRIM_BOTH, SQL_SSF_TRIM_LEADING, SQL_SSF_TRIM_TRAILING
-
SQL_FN_NUM_ABS, SQL_FN_NUM_ACOS, SQL_FN_NUM_ASIN, SQL_FN_NUM_ATAN, SQL_FN_NUM_ATAN2, SQL_FN_NUM_CEILING, SQL_FN_NUM_COS, SQL_FN_NUM_COT, SQL_FN_NUM_EXP, SQL_FN_NUM_FLOOR, SQL_FN_NUM_LOG, SQL_FN_NUM_MOD, SQL_FN_NUM_SIGN, SQL_FN_NUM_SIN, SQL_FN_NUM_SQRT, SQL_FN_NUM_TAN, SQL_FN_NUM_PI, SQL_FN_NUM_RAND, SQL_FN_NUM_DEGREES, SQL_FN_NUM_LOG10, SQL_FN_NUM_POWER, SQL_FN_NUM_RADIANS, SQL_FN_NUM_ROUND, SQL_FN_NUM_TRUNCATE
NUMERIC_FUNCTIONSfunctions.
-
SQL_SNVF_BIT_LENGTH, SQL_SNVF_CHAR_LENGTH, SQL_SNVF_CHARACTER_LENGTH, SQL_SNVF_EXTRACT, SQL_SNVF_OCTET_LENGTH, SQL_SNVF_POSITION
-
SQL_FN_TD_NOW, SQL_FN_TD_CURDATE, SQL_FN_TD_DAYOFMONTH, SQL_FN_TD_DAYOFWEEK, SQL_FN_TD_DAYOFYEAR, SQL_FN_TD_MONTH, SQL_FN_TD_QUARTER, SQL_FN_TD_WEEK, SQL_FN_TD_YEAR, SQL_FN_TD_CURTIME, SQL_FN_TD_HOUR, SQL_FN_TD_MINUTE, SQL_FN_TD_SECOND, SQL_FN_TD_TIMESTAMPADD, SQL_FN_TD_TIMESTAMPDIFF, SQL_FN_TD_DAYNAME, SQL_FN_TD_MONTHNAME, SQL_FN_TD_CURRENT_DATE, SQL_FN_TD_CURRENT_TIME, SQL_FN_TD_CURRENT_TIMESTAMP, SQL_FN_TD_EXTRACT
TIMEDATE_FUNCTIONSfunctions.
-
SQL_FN_TSI_FRAC_SECOND, SQL_FN_TSI_SECOND, SQL_FN_TSI_MINUTE, SQL_FN_TSI_HOUR, SQL_FN_TSI_DAY, SQL_FN_TSI_WEEK, SQL_FN_TSI_MONTH, SQL_FN_TSI_QUARTER, SQL_FN_TSI_YEAR
TIMEDATE_ADD_INTERVALSandTIMEDATE_DIFF_INTERVALSfunctions.
-
SQL_CA1_NEXT, SQL_CA1_ABSOLUTE, SQL_CA1_RELATIVE, SQL_CA1_BOOKMARK
SupportedFetchScrollFetchOrientation's.
-
SQL_CA1_LOCK_NO_CHANGE, SQL_CA1_LOCK_EXCLUSIVE, SQL_CA1_LOCK_UNLOCK
SupportedSetPosLockType's.
-
SQL_CA1_POS_POSITION, SQL_CA1_POS_UPDATE, SQL_CA1_POS_DELETE, SQL_CA1_POS_REFRESH
SupportedSetPosOperations.
-
SQL_CA1_POSITIONED_UPDATE, SQL_CA1_POSITIONED_DELETE, SQL_CA1_SELECT_FOR_UPDATE
Positioned updates and deletes.
-
SQL_CA1_BULK_ADD, SQL_CA1_BULK_UPDATE_BY_BOOKMARK, SQL_CA1_BULK_DELETE_BY_BOOKMARK, SQL_CA1_BULK_FETCH_BY_BOOKMARK
SupportedBulkOperationsoperations.
-
SQL_CA2_READ_ONLY_CONCURRENCY, SQL_CA2_LOCK_CONCURRENCY, SQL_CA2_OPT_ROWVER_CONCURRENCY, SQL_CA2_OPT_VALUES_CONCURRENCY
Supported values forSCROLL_CONCURRENCY.
-
SQL_CA2_SENSITIVITY_ADDITIONS, SQL_CA2_SENSITIVITY_DELETIONS, SQL_CA2_SENSITIVITY_UPDATES
Sensitivity of the cursor to its own inserts, deletes, and updates.
-
SQL_CA2_MAX_ROWS_SELECT, SQL_CA2_MAX_ROWS_INSERT, SQL_CA2_MAX_ROWS_DELETE, SQL_CA2_MAX_ROWS_UPDATE, SQL_CA2_MAX_ROWS_CATALOG, SQL_CA2_MAX_ROWS_AFFECTS_ALL
Semantics ofATTR_MAX_ROWS.
-
SQL_CA2_CRC_EXACT, SQL_CA2_CRC_APPROXIMATE
Semantics ofDIAG_CURSOR_ROW_COUNT.
-
SQL_CA2_SIMULATE_NON_UNIQUE, SQL_CA2_SIMULATE_TRY_UNIQUE, SQL_CA2_SIMULATE_UNIQUE
The kinds of positioned statements that can be simulated.
-
SQL_SO_FORWARD_ONLY, SQL_SO_KEYSET_DRIVEN, SQL_SO_DYNAMIC, SQL_SO_MIXED, SQL_SO_STATIC
SCROLL_OPTIONSmasks.
-
SQL_NC_START, SQL_NC_END
NULL_COLLATIONvalues.
-
SQL_PS_POSITIONED_DELETE, SQL_PS_POSITIONED_UPDATE, SQL_PS_SELECT_FOR_UPDATE
POSITIONED_STATEMENTSmasks.
-
SQL_GB_NOT_SUPPORTED, SQL_GB_GROUP_BY_EQUALS_SELECT, SQL_GB_GROUP_BY_CONTAINS_SELECT, SQL_GB_NO_RELATION, SQL_GB_COLLATE
GROUP_BYvalues.
-
SQL_OU_DML_STATEMENTS, SQL_OU_PROCEDURE_INVOCATION, SQL_OU_TABLE_DEFINITION, SQL_OU_INDEX_DEFINITION, SQL_OU_PRIVILEGE_DEFINITION
OWNER_USAGEmasks.
-
SQL_SU_DML_STATEMENTS, SQL_SU_PROCEDURE_INVOCATION, SQL_SU_TABLE_DEFINITION, SQL_SU_INDEX_DEFINITION, SQL_SU_PRIVILEGE_DEFINITION
SCHEMA_USAGEmasks.
-
SQL_QU_DML_STATEMENTS, SQL_QU_PROCEDURE_INVOCATION, SQL_QU_TABLE_DEFINITION, SQL_QU_INDEX_DEFINITION, SQL_QU_PRIVILEGE_DEFINITION
QUALIFIER_USAGEmasks.
-
SQL_CU_DML_STATEMENTS, SQL_CU_PROCEDURE_INVOCATION, SQL_CU_TABLE_DEFINITION, SQL_CU_INDEX_DEFINITION, SQL_CU_PRIVILEGE_DEFINITION
CATALOG_USAGEmasks.
-
SQL_SQ_COMPARISON, SQL_SQ_EXISTS, SQL_SQ_IN, SQL_SQ_QUANTIFIED, SQL_SQ_CORRELATED_SUBQUERIES
SUBQUERIESmasks.
-
SQL_U_UNION, SQL_U_UNION_ALL
UNIONmasks.
-
SQL_BP_CLOSE, SQL_BP_DELETE, SQL_BP_DROP, SQL_BP_TRANSACTION, SQL_BP_UPDATE, SQL_BP_OTHER_HSTMT, SQL_BP_SCROLL
BOOKMARK_PERSISTENCEvalues.
-
SQL_CV_CREATE_VIEW, SQL_CV_CHECK_OPTION, SQL_CV_CASCADED, SQL_CV_LOCAL
VIEWvalues.
-
SQL_POS_POSITION, SQL_POS_REFRESH, SQL_POS_UPDATE, SQL_POS_DELETE, SQL_POS_ADD
POS_OPERATIONSmasks.
-
SQL_QL_START, SQL_QL_END
QUALIFIER_LOCATIONvalues.
-
SQL_AF_AVG, SQL_AF_COUNT, SQL_AF_MAX, SQL_AF_MIN, SQL_AF_SUM, SQL_AF_DISTINCT, SQL_AF_ALL
AGGREGATE_FUNCTIONSbitmasks.
-
SQL_SC_SQL92_ENTRY, SQL_SC_FIPS127_2_TRANSITIONAL, SQL_SC_SQL92_INTERMEDIATE, SQL_SC_SQL92_FULL
SQL_CONFORMANCEbit masks.
-
SQL_DL_SQL92_DATE, SQL_DL_SQL92_TIME, SQL_DL_SQL92_TIMESTAMP, SQL_DL_SQL92_INTERVAL_YEAR, SQL_DL_SQL92_INTERVAL_MONTH, SQL_DL_SQL92_INTERVAL_DAY, SQL_DL_SQL92_INTERVAL_HOUR, SQL_DL_SQL92_INTERVAL_MINUTE, SQL_DL_SQL92_INTERVAL_SECOND, SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH, SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR, SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE, SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND, SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE, SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND, SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND
DATETIME_LITERALSmasks.
-
SQL_CL_START, SQL_CL_END
CATALOG_LOCATIONvalues.
-
SQL_BRC_PROCEDURES, SQL_BRC_EXPLICIT, SQL_BRC_ROLLED_UP
Values forBATCH_ROW_COUNT.
-
SQL_BS_SELECT_EXPLICIT, SQL_BS_ROW_COUNT_EXPLICIT, SQL_BS_SELECT_PROC, SQL_BS_ROW_COUNT_PROC
Bitmasks forBATCH_SUPPORT.
-
SQL_PARC_BATCH, SQL_PARC_NO_BATCH
Values forPARAM_ARRAY_ROW_COUNTSgetinfo.
-
SQL_PAS_BATCH, SQL_PAS_NO_BATCH, SQL_PAS_NO_SELECT
Values forPARAM_ARRAY_SELECTS.
-
SQL_IK_NONE, SQL_IK_ASC, SQL_IK_DESC, SQL_IK_ALL
Bitmasks forINDEX_KEYWORDS.
-
SQL_ISV_ASSERTIONS, SQL_ISV_CHARACTER_SETS, SQL_ISV_CHECK_CONSTRAINTS, SQL_ISV_COLLATIONS, SQL_ISV_COLUMN_DOMAIN_USAGE, SQL_ISV_COLUMN_PRIVILEGES, SQL_ISV_COLUMNS, SQL_ISV_CONSTRAINT_COLUMN_USAGE, SQL_ISV_CONSTRAINT_TABLE_USAGE, SQL_ISV_DOMAIN_CONSTRAINTS, SQL_ISV_DOMAINS, SQL_ISV_KEY_COLUMN_USAGE, SQL_ISV_REFERENTIAL_CONSTRAINTS, SQL_ISV_SCHEMATA, SQL_ISV_SQL_LANGUAGES, SQL_ISV_TABLE_CONSTRAINTS, SQL_ISV_TABLE_PRIVILEGES, SQL_ISV_TABLES, SQL_ISV_TRANSLATIONS, SQL_ISV_USAGE_PRIVILEGES, SQL_ISV_VIEW_COLUMN_USAGE, SQL_ISV_VIEW_TABLE_USAGE, SQL_ISV_VIEWS
Bitmasks forINFO_SCHEMA_VIEWS.
-
SQL_AM_NONE, SQL_AM_CONNECTION, SQL_AM_STATEMENT
Bitmasks forASYNC_MODE.
-
SQL_AD_CONSTRAINT_NAME_DEFINITION, SQL_AD_ADD_DOMAIN_CONSTRAINT, SQL_AD_DROP_DOMAIN_CONSTRAINT, SQL_AD_ADD_DOMAIN_DEFAULT, SQL_AD_DROP_DOMAIN_DEFAULT, SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED, SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE, SQL_AD_ADD_CONSTRAINT_DEFERRABLE, SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE
Bitmasks forALTER_DOMAIN.
-
SQL_CTR_CREATE_TRANSLATION
CREATE_TRANSLATIONbitmasks.
-
SQL_CA_CREATE_ASSERTION, SQL_CA_CONSTRAINT_INITIALLY_DEFERRED, SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE, SQL_CA_CONSTRAINT_DEFERRABLE, SQL_CA_CONSTRAINT_NON_DEFERRABLE
CREATE_ASSERTIONbitmasks.
-
SQL_CCS_CREATE_CHARACTER_SET, SQL_CCS_COLLATE_CLAUSE, SQL_CCS_LIMITED_COLLATION
CREATE_CHARACTER_SETbitmasks.
-
SQL_CCOL_CREATE_COLLATION
CREATE_COLLATIONbitmasks.
-
SQL_CDO_CREATE_DOMAIN, SQL_CDO_DEFAULT, SQL_CDO_CONSTRAINT, SQL_CDO_COLLATION, SQL_CDO_CONSTRAINT_NAME_DEFINITION, SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED, SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE, SQL_CDO_CONSTRAINT_DEFERRABLE, SQL_CDO_CONSTRAINT_NON_DEFERRABLE
CREATE_DOMAINbitmasks.
-
SQL_CT_CREATE_TABLE, SQL_CT_COMMIT_PRESERVE, SQL_CT_COMMIT_DELETE, SQL_CT_GLOBAL_TEMPORARY, SQL_CT_LOCAL_TEMPORARY, SQL_CT_CONSTRAINT_INITIALLY_DEFERRED, SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE, SQL_CT_CONSTRAINT_DEFERRABLE, SQL_CT_CONSTRAINT_NON_DEFERRABLE, SQL_CT_COLUMN_CONSTRAINT, SQL_CT_COLUMN_DEFAULT, SQL_CT_COLUMN_COLLATION, SQL_CT_TABLE_CONSTRAINT, SQL_CT_CONSTRAINT_NAME_DEFINITION
CREATE_TABLEbitmasks.
-
SQL_DI_CREATE_INDEX, SQL_DI_DROP_INDEX
DDL_INDEXbitmasks.
-
SQL_DC_DROP_COLLATION
DROP_COLLATIONbitmasks.
-
SQL_DD_DROP_DOMAIN, SQL_DD_RESTRICT, SQL_DD_CASCADE
DROP_DOMAINbitmasks.
-
SQL_DS_DROP_SCHEMA, SQL_DS_RESTRICT, SQL_DS_CASCADE
DROP_SCHEMAbitmasks.
-
SQL_DCS_DROP_CHARACTER_SET
DROP_CHARACTER_SETbitmasks.
-
SQL_DA_DROP_ASSERTION
DROP_ASSERTIONbitmasks.
-
SQL_DT_DROP_TABLE, SQL_DT_RESTRICT, SQL_DT_CASCADE
DROP_TABLEbitmasks.
-
SQL_DTR_DROP_TRANSLATION
DROP_TRANSLATIONbitmasks.
-
SQL_DV_DROP_VIEW, SQL_DV_RESTRICT, SQL_DV_CASCADE
DROP_VIEWbitmasks.
-
SQL_SFKD_CASCADE, SQL_SFKD_NO_ACTION, SQL_SFKD_SET_DEFAULT, SQL_SFKD_SET_NULL
SQL92_FOREIGN_KEY_DELETE_RULEbitmasks.
-
SQL_SFKU_CASCADE, SQL_SFKU_NO_ACTION, SQL_SFKU_SET_DEFAULT, SQL_SFKU_SET_NULL
SQL92_FOREIGN_KEY_UPDATE_RULEbitmasks.
-
SQL_SG_USAGE_ON_DOMAIN, SQL_SG_USAGE_ON_CHARACTER_SET, SQL_SG_USAGE_ON_COLLATION, SQL_SG_USAGE_ON_TRANSLATION, SQL_SG_WITH_GRANT_OPTION, SQL_SG_DELETE_TABLE, SQL_SG_INSERT_TABLE, SQL_SG_INSERT_COLUMN, SQL_SG_REFERENCES_TABLE, SQL_SG_REFERENCES_COLUMN, SQL_SG_SELECT_TABLE, SQL_SG_UPDATE_TABLE, SQL_SG_UPDATE_COLUMN
SQL92_GRANTbitmasks.
-
SQL_SP_EXISTS, SQL_SP_ISNOTNULL, SQL_SP_ISNULL, SQL_SP_MATCH_FULL, SQL_SP_MATCH_PARTIAL, SQL_SP_MATCH_UNIQUE_FULL, SQL_SP_MATCH_UNIQUE_PARTIAL, SQL_SP_OVERLAPS, SQL_SP_UNIQUE, SQL_SP_LIKE, SQL_SP_IN, SQL_SP_BETWEEN, SQL_SP_COMPARISON, SQL_SP_QUANTIFIED_COMPARISON
SQL92_PREDICATESbitmasks.
-
SQL_SRJO_CORRESPONDING_CLAUSE, SQL_SRJO_CROSS_JOIN, SQL_SRJO_EXCEPT_JOIN, SQL_SRJO_FULL_OUTER_JOIN, SQL_SRJO_INNER_JOIN, SQL_SRJO_INTERSECT_JOIN, SQL_SRJO_LEFT_OUTER_JOIN, SQL_SRJO_NATURAL_JOIN, SQL_SRJO_RIGHT_OUTER_JOIN, SQL_SRJO_UNION_JOIN
SQL92_RELATIONAL_JOIN_OPERATORSbitmasks.
-
SQL_SR_USAGE_ON_DOMAIN, SQL_SR_USAGE_ON_CHARACTER_SET, SQL_SR_USAGE_ON_COLLATION, SQL_SR_USAGE_ON_TRANSLATION, SQL_SR_GRANT_OPTION_FOR, SQL_SR_CASCADE, SQL_SR_RESTRICT, SQL_SR_DELETE_TABLE, SQL_SR_INSERT_TABLE, SQL_SR_INSERT_COLUMN, SQL_SR_REFERENCES_TABLE, SQL_SR_REFERENCES_COLUMN, SQL_SR_SELECT_TABLE, SQL_SR_UPDATE_TABLE, SQL_SR_UPDATE_COLUMN
SQL92_REVOKEbitmasks.
-
SQL_SRVC_VALUE_EXPRESSION, SQL_SRVC_NULL, SQL_SRVC_DEFAULT, SQL_SRVC_ROW_SUBQUERY
SQL92_ROW_VALUE_CONSTRUCTORbitmasks.
-
SQL_US_UNION, SQL_US_UNION_ALL
UNION_STATEMENTbitmasks.
-
SQL_DRIVER_AWARE_POOLING_NOT_CAPABLE, SQL_DRIVER_AWARE_POOLING_CAPABLE
Values forDRIVER_AWARE_POOLING_SUPPORTED.
-
SQL_ASYNC_DBC_NOT_CAPABLE, SQL_ASYNC_DBC_CAPABLE
Possible values forASYNC_DBC_FUNCTIONS.
-
SQL_FETCH_FIRST_USER, SQL_FETCH_FIRST_SYSTEM
AdditionalDataSourcesfetch directions.
-
SQL_ENTIRE_ROWSET
Defines forSetPos.
-
SQL_BEST_ROWID, SQL_ROWVER
Column types and scopes inSpecialColumns.
-
SQL_PC_NOT_PSEUDO
Defines forSpecialColumns(returned in the result set).
-
SQL_QUICK, SQL_ENSURE
Defines forStatistics.
-
SQL_TABLE_STAT
Defines forStatistics(returned in the result set).
-
SQL_ALL_CATALOGS, SQL_ALL_SCHEMAS, SQL_ALL_TABLE_TYPES
Defines forTables.
-
SQL_FETCH_BOOKMARK
ExtendedFetchfFetchTypevalues.
-
SQL_ROW_SUCCESS, SQL_ROW_DELETED, SQL_ROW_UPDATED, SQL_ROW_NOROW, SQL_ROW_ADDED, SQL_ROW_ERROR, SQL_ROW_SUCCESS_WITH_INFO, SQL_ROW_PROCEED, SQL_ROW_IGNORE
ExtendedFetchrgfRowStatuselement values.
-
SQL_PARAM_SUCCESS, SQL_PARAM_SUCCESS_WITH_INFO, SQL_PARAM_ERROR, SQL_PARAM_UNUSED, SQL_PARAM_DIAG_UNAVAILABLE, SQL_PARAM_PROCEED, SQL_PARAM_IGNORE
Value forDESC_ARRAY_STATUS_PTR.
-
SQL_CASCADE, SQL_RESTRICT, SQL_SET_NULL, SQL_NO_ACTION, SQL_SET_DEFAULT, SQL_INITIALLY_DEFERRED, SQL_INITIALLY_IMMEDIATE, SQL_NOT_DEFERRABLE
Defines forForeignKeys(UPDATE_RULE and DELETE_RULE).
-
SQL_PT_UNKNOWN, SQL_PT_PROCEDURE, SQL_PT_FUNCTION
Defines forProcedures(returned in the result set).
-
SQL_IS_YEAR, SQL_IS_MONTH, SQL_IS_DAY, SQL_IS_HOUR, SQL_IS_MINUTE, SQL_IS_SECOND, SQL_IS_YEAR_TO_MONTH, SQL_IS_DAY_TO_HOUR, SQL_IS_DAY_TO_MINUTE, SQL_IS_DAY_TO_SECOND, SQL_IS_HOUR_TO_MINUTE, SQL_IS_HOUR_TO_SECOND, SQL_IS_MINUTE_TO_SECOND
SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.
-
SQL_MAX_NUMERIC_LEN
Internal representation of numeric data type.
-
SQL_DRIVER_NOPROMPT, SQL_DRIVER_COMPLETE, SQL_DRIVER_PROMPT, SQL_DRIVER_COMPLETE_REQUIRED
Options forDriverConnect.
-
SQL_POSITION, SQL_REFRESH, SQL_UPDATE, SQL_DELETE
Operations inSetPos.
-
SQL_ADD, SQL_SETPOS_MAX_OPTION_VALUE, SQL_UPDATE_BY_BOOKMARK, SQL_DELETE_BY_BOOKMARK, SQL_FETCH_BY_BOOKMARK
Operations inBulkOperations.
-
SQL_LOCK_NO_CHANGE, SQL_LOCK_EXCLUSIVE, SQL_LOCK_UNLOCK, SQL_SETPOS_MAX_LOCK_VALUE
Lock options inSetPos.
-
-
Method Detail
-
getLibrary
public static SharedLibrary getLibrary()
Returns the odbcSharedLibrary.
-
nSQLAllocHandle
public static short nSQLAllocHandle(short HandleType, long InputHandle, long OutputHandle)Unsafe version of:AllocHandle
-
SQLAllocHandle
public static short SQLAllocHandle(short HandleType, long InputHandle, PointerBuffer OutputHandle)MSDN ReferenceAllocates an environment, connection, statement, or descriptor handle.
- Parameters:
HandleType- the type of handle to be allocated. One of:HANDLE_ENVHANDLE_DBCHANDLE_STMTHANDLE_DESCHANDLE_SENVInputHandle- the input handle in whose context the new handle is to be allocated. IfHandleTypeisHANDLE_ENV, this isNULL_HANDLE. IfHandleTypeisHANDLE_DBC, this must be an environment handle, and if it isHANDLE_STMTorHANDLE_DESC, it must be a connection handle.OutputHandle- pointer to a buffer in which to return the handle to the newly allocated data structure- Returns:
SUCCESS,SUCCESS_WITH_INFO,INVALID_HANDLE, orERROR.When allocating a handle other than an environment handle, if SQLAllocHandle returns
ERROR, it setsOutputHandletoNULL_HDBC,NULL_HSTMT, orNULL_HDESC, depending on the value ofHandleType, unless the output argument is a null pointer. The application can then obtain additional information from the diagnostic data structure associated with the handle in theInputHandleargument.
-
nSQLConnect
public static short nSQLConnect(long ConnectionHandle, long ServerName, short NameLength1, long UserName, short NameLength2, long Authentication, short NameLength3)Unsafe version of:Connect- Parameters:
NameLength1- the length of*ServerNamein charactersNameLength2- the length of*UserNamein charactersNameLength3- the length of*Authenticationin characters
-
SQLConnect
public static short SQLConnect(long ConnectionHandle, java.nio.ByteBuffer ServerName, java.nio.ByteBuffer UserName, java.nio.ByteBuffer Authentication) public static short SQLConnect(long ConnectionHandle, java.lang.CharSequence ServerName, java.lang.CharSequence UserName, java.lang.CharSequence Authentication)MSDN ReferenceEstablishes connections to a driver and a data source. The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.
- Parameters:
ConnectionHandle- the connection handleServerName- the data source name. The data might be located on the same computer as the program, or on another computer somewhere on a networkUserName- the user identifierAuthentication- the authentication string (typically the password)- Returns:
SUCCESS,SUCCESS_WITH_INFO,ERROR,INVALID_HANDLE, orSTILL_EXECUTING
-
nSQLDataSources
public static short nSQLDataSources(long EnvironmentHandle, short Direction, long ServerName, short BufferLength1, long NameLength1Ptr, long Description, short BufferLength2, long NameLength2Ptr)Unsafe version of:DataSources- Parameters:
BufferLength1- length of the*ServerNamebuffer, in characters; this does not need to be longer thanMAX_DSN_LENGTHplus the null-termination character.BufferLength2- length in characters of the*Descriptionbuffer.
-
SQLDataSources
public static short SQLDataSources(long EnvironmentHandle, short Direction, @Nullable java.nio.ByteBuffer ServerName, java.nio.ShortBuffer NameLength1Ptr, @Nullable java.nio.ByteBuffer Description, java.nio.ShortBuffer NameLength2Ptr)MSDN ReferenceReturns information about a data source. This function is implemented only by the Driver Manager.
- Parameters:
EnvironmentHandle- the environment handleDirection- determines which data source the Driver Manager returns information about. Can be:FETCH_NEXT(to fetch the next data source name in the list),FETCH_FIRST(to fetch from the beginning of the list),FETCH_FIRST_USER(to fetch the first user DSN), orFETCH_FIRST_SYSTEM(to fetch the first system DSN).When
Directionis set toFETCH_FIRST, subsequent calls to SQLDataSources withDirectionset toFETCH_NEXTreturn both user and system DSNs. WhenDirectionis set toFETCH_FIRST_USER, all subsequent calls to SQLDataSources withDirectionset toFETCH_NEXTreturn only user DSNs. WhenDirectionis set toFETCH_FIRST_SYSTEM, all subsequent calls to SQLDataSources withDirectionset toFETCH_NEXTreturn only system DSNs.ServerName- pointer to a buffer in which to return the data source nameIf
ServerNameisNULL,NameLength1Ptrwill still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to byServerName.NameLength1Ptr- pointer to a buffer in which to return the total number of characters (excluding the null-termination character) available to return in*ServerName. If the number of characters available to return is greater than or equal toBufferLength1, the data source name in*ServerNameis truncated toBufferLength1minus the length of a null-termination character.Description- pointer to a buffer in which to return the description of the driver associated with the data source. For example, dBASE or SQL Server.If
DescriptionisNULL,NameLength2Ptrwill still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to byDescription.NameLength2Ptr- pointer to a buffer in which to return the total number of characters (excluding the null-termination character) available to return in*Description. If the number of characters available to return is greater than or equal toBufferLength2, the driver description in*Descriptionis truncated toBufferLength2minus the length of a null-termination character.- Returns:
SUCCESS,SUCCESS_WITH_INFO,NO_DATA,ERROR, orINVALID_HANDLE
-
nSQLGetInfo
public static short nSQLGetInfo(long ConnectionHandle, short InfoType, long InfoValuePtr, short BufferLength, long StringLengthPtr)Unsafe version of:GetInfo
-
SQLGetInfo
public static short SQLGetInfo(long ConnectionHandle, short InfoType, @Nullable java.nio.ByteBuffer InfoValuePtr, @Nullable java.nio.ShortBuffer StringLengthPtr) public static short SQLGetInfo(long ConnectionHandle, short InfoType, @Nullable java.nio.ShortBuffer InfoValuePtr, @Nullable java.nio.ShortBuffer StringLengthPtr) public static short SQLGetInfo(long ConnectionHandle, short InfoType, @Nullable java.nio.IntBuffer InfoValuePtr, @Nullable java.nio.ShortBuffer StringLengthPtr) public static short SQLGetInfo(long ConnectionHandle, short InfoType, @Nullable PointerBuffer InfoValuePtr, @Nullable java.nio.ShortBuffer StringLengthPtr)MSDN ReferenceReturns general information about the driver and data source associated with a connection.
- Parameters:
ConnectionHandle- the connection handleInfoType- type of information. One of:
-
nSQLGetFunctions
public static short nSQLGetFunctions(long ConnectionHandle, short FunctionId, long SupportedPtr)Unsafe version of:GetFunctions
-
SQLGetFunctions
public static short SQLGetFunctions(long ConnectionHandle, short FunctionId, java.nio.ShortBuffer SupportedPtr)MSDN ReferenceReturns information about whether a driver supports a specific ODBC function. This function is implemented in the Driver Manager; it can also be implemented in drivers. If a driver implements SQLGetFunctions, the Driver Manager calls the function in the driver. Otherwise, it executes the function itself.
- Parameters:
ConnectionHandle- the connection handleFunctionId- identifies the ODBC function of interest. One of:
-
SQLGetTypeInfo
public static short SQLGetTypeInfo(long StatementHandle, short DataType)MSDN ReferenceReturns information about data types supported by the data source. The driver returns the information in the form of an SQL result set. The data types are intended for use in Data Definition Language (DDL) statements.
- Parameters:
StatementHandle- the statement handle for the result setDataType- the SQL data type. This must be one of the values in the SQL Data Types section of Appendix D: Data Types, or a driver-specific SQL data type.ALL_TYPESspecifies that information about all data types should be returned.
-
nSQLSetConnectAttr
public static short nSQLSetConnectAttr(long ConnectionHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetConnectAttr- Parameters:
StringLength- ifAttributeis an ODBC-defined attribute andValuepoints to a character string or a binary buffer, this argument should be the length of*ValuePtr. For character string data, this argument should contain the number of bytes in the string.If
Attributeis an ODBC-defined attribute andValueis an integer,StringLengthis ignored.If
Attributeis a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting theStringLengthargument.StringLengthcan have the following values:- If
Valueis a pointer to a character string, thenStringLengthis the length of the string orNTS. - If
Valueis a pointer to a binary buffer, then the application places the result of theSQL_LEN_BINARY_ATTR(length)macro inStringLength. This places a negative value inStringLength. - If
Valueis a pointer to a value other than a character string or a binary string, thenStringLengthshould have the valueIS_POINTER. - If
ValuePtrcontains a fixed-length value, thenStringLengthis eitherIS_INTEGERorIS_UINTEGER, as appropriate.
- If
-
SQLSetConnectAttr
public static short SQLSetConnectAttr(long ConnectionHandle, int Attribute, @Nullable java.nio.ByteBuffer Value)MSDN ReferenceSets attributes that govern aspects of connections.
- Parameters:
ConnectionHandle- the connection handleAttribute- the attribute to set. One of:Value- pointer to the value to be associated withAttribute. Depending on the value ofAttribute,Valuewill be an unsigned integer value or will point to a null-terminated character string. Note that the integral type of theAttributeargument may not be fixed length.- Returns:
SUCCESS,SUCCESS_WITH_INFO,ERROR,INVALID_HANDLE, orSTILL_EXECUTING
-
nSQLGetConnectAttr
public static short nSQLGetConnectAttr(long ConnectionHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetConnectAttr
-
SQLGetConnectAttr
public static short SQLGetConnectAttr(long ConnectionHandle, int Attribute, @Nullable java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)MSDN ReferenceReturns the current setting of a connection attribute.
- Parameters:
ConnectionHandle- the connection handleAttribute- attribute to retrieve. One of:
-
nSQLSetEnvAttr
public static short nSQLSetEnvAttr(long EnvironmentHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetEnvAttr- Parameters:
StringLength- ifValuepoints to a character string or a binary buffer, this argument should be the length of*Value. For character string data, this argument should contain the number of bytes in the string.
-
SQLSetEnvAttr
public static short SQLSetEnvAttr(long EnvironmentHandle, int Attribute, @Nullable java.nio.ByteBuffer Value)MSDN ReferenceSets attributes that govern aspects of environments.
- Parameters:
EnvironmentHandle- the environment handleAttribute- the attribute to set. One of:ATTR_OUTPUT_NTSATTR_ODBC_VERSIONATTR_CONNECTION_POOLINGATTR_CP_MATCHValue- pointer to the value to be associated withAttribute. Depending on the value ofAttribute,Valuewill be a 32-bit integer value or point to a null-terminated character string.- Returns:
SUCCESS,SUCCESS_WITH_INFO,ERROR, orINVALID_HANDLE
-
nSQLGetEnvAttr
public static short nSQLGetEnvAttr(long EnvironmentHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetEnvAttr
-
SQLGetEnvAttr
public static short SQLGetEnvAttr(long EnvironmentHandle, int Attribute, @Nullable java.nio.ByteBuffer ValuePtr, java.nio.IntBuffer StringLengthPtr)MSDN ReferenceReturns the current setting of a connection attribute.
- Parameters:
Attribute- one of:ATTR_OUTPUT_NTSATTR_ODBC_VERSIONATTR_CONNECTION_POOLINGATTR_CP_MATCH
-
nSQLSetStmtAttr
public static short nSQLSetStmtAttr(long StatementHandle, int Attribute, long Value, int StringLength)Unsafe version of:SetStmtAttr
-
SQLSetStmtAttr
public static short SQLSetStmtAttr(long StatementHandle, int Attribute, @Nullable java.nio.ByteBuffer Value)MSDN ReferenceSets attributes related to a statement.
- Parameters:
StatementHandle- the statement handleAttribute- the attribute to set. One of:
-
nSQLGetStmtAttr
public static short nSQLGetStmtAttr(long StatementHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetStmtAttr
-
SQLGetStmtAttr
public static short SQLGetStmtAttr(long StatementHandle, int Attribute, @Nullable java.nio.ByteBuffer ValuePtr, @Nullable java.nio.IntBuffer StringLengthPtr)MSDN ReferenceReturns the current setting of a statement attribute.
- Parameters:
Attribute- one of:
-
nSQLGetDescField
public static short nSQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength, long StringLengthPtr)Unsafe version of:GetDescField
-
SQLGetDescField
public static short SQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, @Nullable java.nio.ByteBuffer ValuePtr, @Nullable java.nio.IntBuffer StringLengthPtr)MSDN ReferenceReturns the current setting or value of a single field of a descriptor record.
-
nSQLGetDescRec
public static short nSQLGetDescRec(long DescriptorHandle, short RecNumber, long Name, short BufferLength, long StringLengthPtr, long TypePtr, long SubTypePtr, long LengthPtr, long PrecisionPtr, long ScalePtr, long NullablePtr)Unsafe version of:GetDescRec
-
SQLGetDescRec
public static short SQLGetDescRec(long DescriptorHandle, short RecNumber, @Nullable java.nio.ByteBuffer Name, @Nullable java.nio.ShortBuffer StringLengthPtr, @Nullable java.nio.ShortBuffer TypePtr, @Nullable java.nio.ShortBuffer SubTypePtr, @Nullable PointerBuffer LengthPtr, @Nullable java.nio.ShortBuffer PrecisionPtr, @Nullable java.nio.ShortBuffer ScalePtr, @Nullable java.nio.ShortBuffer NullablePtr)MSDN ReferenceReturns the current settings or values of multiple fields of a descriptor record. The fields returned describe the name, data type, and storage of column or parameter data.
-
nSQLSetDescField
public static short nSQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength)Unsafe version of:SetDescField
-
SQLSetDescField
public static short SQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, java.nio.ByteBuffer ValuePtr)MSDN ReferenceSets the value of a single field of a descriptor record.
-
nSQLSetDescRec
public static short nSQLSetDescRec(long DescriptorHandle, short RecNumber, short Type, short SubType, long Length, short Precision, short Scale, long DataPtr, long StringLengthPtr, long IndicatorPtr)Unsafe version of:SetDescRec
-
SQLSetDescRec
public static short SQLSetDescRec(long DescriptorHandle, short RecNumber, short Type, short SubType, long Length, short Precision, short Scale, @Nullable java.nio.ByteBuffer DataPtr, @Nullable PointerBuffer StringLengthPtr, @Nullable PointerBuffer IndicatorPtr)MSDN ReferenceSets multiple descriptor fields that affect the data type and buffer bound to a column or parameter data.
-
SQLCopyDesc
public static short SQLCopyDesc(long SourceDescHandle, long TargetDescHandle)MSDN ReferenceCopies descriptor information from one descriptor handle to another.
-
nSQLPrepare
public static short nSQLPrepare(long StatementHandle, long StatementText, int TextLength)Unsafe version of:Prepare
-
SQLPrepare
public static short SQLPrepare(long StatementHandle, java.nio.ByteBuffer StatementText) public static short SQLPrepare(long StatementHandle, java.lang.CharSequence StatementText)MSDN ReferencePrepares an SQL string for execution.
-
nSQLGetCursorName
public static short nSQLGetCursorName(long StatementHandle, long CursorName, short BufferLength, long NameLengthPtr)Unsafe version of:GetCursorName
-
SQLGetCursorName
public static short SQLGetCursorName(long StatementHandle, @Nullable java.nio.ByteBuffer CursorName, java.nio.ShortBuffer NameLengthPtr)MSDN ReferenceReturns the cursor name associated with a specified statement.
-
nSQLSetCursorName
public static short nSQLSetCursorName(long StatementHandle, long CursorName, short NameLength)Unsafe version of:SetCursorName
-
SQLSetCursorName
public static short SQLSetCursorName(long StatementHandle, java.nio.ByteBuffer CursorName)MSDN ReferenceAssociates a cursor name with an active statement. If an application does not call SQLSetCursorName, the driver generates cursor names as needed for SQL statement processing.
-
SQLExecute
public static short SQLExecute(long StatementHandle)
MSDN ReferenceExecutes a prepared statement, using the current values of the parameter marker variables if any parameter markers exist in the statement.
- Parameters:
StatementHandle- statement handle
-
nSQLExecDirect
public static short nSQLExecDirect(long StatementHandle, long StatementText, int TextLength)Unsafe version of:ExecDirect- Parameters:
TextLength- length ofStatementTextin characters
-
SQLExecDirect
public static short SQLExecDirect(long StatementHandle, java.nio.ByteBuffer StatementText) public static short SQLExecDirect(long StatementHandle, java.lang.CharSequence StatementText)MSDN ReferenceExecutes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement. SQLExecDirect is the fastest way to submit an SQL statement for one-time execution.
- Parameters:
StatementHandle- statement handleStatementText- SQL statement to be executed
-
nSQLParamData
public static short nSQLParamData(long StatementHandle, long ValuePtrPtr)Unsafe version of:ParamData
-
SQLParamData
public static short SQLParamData(long StatementHandle, PointerBuffer ValuePtrPtr)MSDN ReferenceSQLParamData is used together with
PutDatato supply parameter data at statement execution time, and withGetDatato retrieve streamed output parameter data.
-
nSQLPutData
public static short nSQLPutData(long StatementHandle, long DataPtr, long StrLen_or_Ind)Unsafe version of:PutData
-
SQLPutData
public static short SQLPutData(long StatementHandle, java.nio.ByteBuffer DataPtr)MSDN ReferenceAllows an application to send data for a parameter or column to the driver at statement execution time. This function can be used to send character or binary data values in parts to a column with a character, binary, or data source–specific data type (for example, parameters of the
LONGVARBINARYorLONGVARCHARtypes). SQLPutData supports binding to a Unicode C data type, even if the underlying driver does not support Unicode data.
-
nSQLRowCount
public static short nSQLRowCount(long StatementHandle, long RowCountPtr)Unsafe version of:RowCount
-
SQLRowCount
public static short SQLRowCount(long StatementHandle, PointerBuffer RowCountPtr)MSDN ReferenceReturns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an
ADD,UPDATE_BY_BOOKMARK, orDELETE_BY_BOOKMARKoperation inBulkOperations; or anUPDATEorDELETEoperation inSetPos.
-
nSQLNumResultCols
public static short nSQLNumResultCols(long StatementHandle, long ColumnCountPtr)Unsafe version of:NumResultCols
-
SQLNumResultCols
public static short SQLNumResultCols(long StatementHandle, java.nio.ShortBuffer ColumnCountPtr)MSDN ReferenceReturns the number of columns in a result set.
-
nSQLDescribeCol
public static short nSQLDescribeCol(long StatementHandle, short ColumnNumber, long ColumnName, short BufferLength, long NameLengthPtr, long DataTypePtr, long ColumnSizePtr, long DecimalDigitsPtr, long NullablePtr)Unsafe version of:DescribeCol
-
SQLDescribeCol
public static short SQLDescribeCol(long StatementHandle, short ColumnNumber, @Nullable java.nio.ByteBuffer ColumnName, java.nio.ShortBuffer NameLengthPtr, java.nio.ShortBuffer DataTypePtr, PointerBuffer ColumnSizePtr, java.nio.ShortBuffer DecimalDigitsPtr, java.nio.ShortBuffer NullablePtr)MSDN ReferenceReturns the result descriptor — column name,type, column size, decimal digits, and nullability — for one column in the result set. This information also is available in the fields of the IRD.
-
nSQLColAttribute
public static short nSQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, long CharacterAttributePtr, short BufferLength, long StringLengthPtr, long NumericAttributePtr)Unsafe version of:ColAttribute
-
SQLColAttribute
public static short SQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, @Nullable java.nio.ByteBuffer CharacterAttributePtr, java.nio.ShortBuffer StringLengthPtr, PointerBuffer NumericAttributePtr)MSDN ReferenceReturns descriptor information for a column in a result set. Descriptor information is returned as a character string, a descriptor-dependent value, or an integer value.
-
nSQLBindCol
public static short nSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, long TargetValuePtr, long BufferLength, long StrLen_or_Ind)Unsafe version of:BindCol
-
SQLBindCol
public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.ByteBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind) public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.ShortBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind) public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.IntBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind) public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.LongBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind) public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.FloatBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind) public static short SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, @Nullable java.nio.DoubleBuffer TargetValuePtr, @Nullable PointerBuffer StrLen_or_Ind)MSDN ReferenceBinds application data buffers to columns in the result set.
-
SQLFetch
public static short SQLFetch(long StatementHandle)
MSDN ReferenceFetches the next rowset of data from the result set and returns data for all bound columns.
-
SQLFetchScroll
public static short SQLFetchScroll(long StatementHandle, short FetchOrientation, long FetchOffset)MSDN ReferenceFetches the specified rowset of data from the result set and returns data for all bound columns. Rowsets can be specified at an absolute or relative position or by bookmark.
- Parameters:
FetchOrientation- one of:FETCH_NEXTFETCH_FIRSTFETCH_LASTFETCH_PRIORFETCH_ABSOLUTEFETCH_RELATIVE
-
nSQLGetData
public static short nSQLGetData(long StatementHandle, short Col_or_Param_Num, short TargetType, long TargetValuePtr, long BufferLength, long StrLen_or_IndPtr)Unsafe version of:GetData
-
SQLGetData
public static short SQLGetData(long StatementHandle, short Col_or_Param_Num, short TargetType, java.nio.ByteBuffer TargetValuePtr, PointerBuffer StrLen_or_IndPtr)MSDN ReferenceRetrieves data for a single column in the result set or for a single parameter after
ParamDatareturnsPARAM_DATA_AVAILABLE. It can be called multiple times to retrieve variable-length data in parts.
-
nSQLGetDiagField
public static short nSQLGetDiagField(short HandleType, long Handle, short RecNumber, short DiagIdentifier, long DiagInfoPtr, short BufferLength, long StringLengthPtr)Unsafe version of:GetDiagField- Parameters:
BufferLength- IfDiagIdentifieris an ODBC-defined diagnostic andDiagInfoPtrpoints to a character string or a binary buffer, this argument should be the length of*DiagInfoPtr. IfDiagIdentifieris an ODBC-defined field and*DiagInfoPtris an integer,BufferLengthis ignored. If the value in*DiagInfoPtris a Unicode string (when callingSQLGetDiagFieldW), theBufferLengthargument must be an even number.If
DiagIdentifieris a driver-defined field, the application indicates the nature of the field to the Driver Manager by setting theBufferLengthargument.BufferLengthcan have the following values:- If is a pointer to a character string,
BufferLengthis the length of the string orNTS. - If
DiagInfoPtris a pointer to a binary buffer, the application places the result of theSQL_LEN_BINARY_ATTR(length)macro inBufferLength. This places a negative value inBufferLength. - If
DiagInfoPtris a pointer to a value other than a character string or binary string,BufferLengthshould have the valueIS_POINTER. - If
*DiagInfoPtrcontains a fixed-length data type,BufferLengthisIS_INTEGER,IS_UINTEGER,IS_SMALLINT, orIS_USMALLINT, as appropriate.
- If is a pointer to a character string,
-
SQLGetDiagField
public static short SQLGetDiagField(short HandleType, long Handle, short RecNumber, short DiagIdentifier, @Nullable java.nio.ByteBuffer DiagInfoPtr, java.nio.ShortBuffer StringLengthPtr)MSDN ReferenceReturns the current value of a field of a record of the diagnostic data structure (associated with a specified handle) that contains error, warning, and status information.
- Parameters:
HandleType- a handle type identifier that describes the type of handle for which diagnostics are required. One of:HANDLE_ENVHANDLE_DBCHANDLE_STMTHANDLE_DESCHANDLE_SENVHandle- a handle for the diagnostic data structure, of the type indicated byHandleType. IfHandleTypeisHANDLE_ENV,Handlecan be either a shared or an unshared environment handle.RecNumber- indicates the status record from which the application seeks information. Status records are numbered from 1. If theDiagIdentifierargument indicates any field of the diagnostics header,RecNumberis ignored. If not, it should be more than 0.DiagIdentifier- indicates the field of the diagnostic whose value is to be returned. One of:DiagInfoPtr- pointer to a buffer in which to return the diagnostic information. The data type depends on the value ofDiagIdentifier. IfDiagInfoPtris an integer type, applications should use a buffer ofSQLULENand initialize the value to 0 before calling this function, as some drivers may only write the lower 32-bit or 16-bit of a buffer and leave the higher-order bit unchanged.If
DiagInfoPtrisNULL,StringLengthPtrwill still return the total number of bytes (excluding the null-termination character for character data) available to return in the buffer pointed to byDiagInfoPtr.StringLengthPtr- Pointer to a buffer in which to return the total number of bytes (excluding the number of bytes required for the null-termination character) available to return in*DiagInfoPtr, for character data. If the number of bytes available to return is greater than or equal toBufferLength, the text in*DiagInfoPtris truncated toBufferLengthminus the length of a null-termination character.
-
nSQLGetDiagRec
public static short nSQLGetDiagRec(short HandleType, long Handle, short RecNumber, long SQLState, long NativeErrorPtr, long MessageText, short BufferLength, long TextLengthPtr)Unsafe version of:GetDiagRec
-
SQLGetDiagRec
public static short SQLGetDiagRec(short HandleType, long Handle, short RecNumber, java.nio.ByteBuffer SQLState, java.nio.IntBuffer NativeErrorPtr, @Nullable java.nio.ByteBuffer MessageText, java.nio.ShortBuffer TextLengthPtr)MSDN ReferenceReturns the current values of multiple fields of a diagnostic record that contains error, warning, and status information. Unlike
GetDiagField, which returns one diagnostic field per call, SQLGetDiagRec returns several commonly used fields of a diagnostic record, including the SQLSTATE, the native error code, and the diagnostic message text.
-
SQLFreeStmt
public static short SQLFreeStmt(long StatementHandle, short Option)MSDN ReferenceStops processing associated with a specific statement, closes any open cursors associated with the statement, discards pending results, or, optionally, frees all resources associated with the statement handle.
- Parameters:
Option- one of:CLOSEDROPUNBINDRESET_PARAMS
-
SQLCloseCursor
public static short SQLCloseCursor(long StatementHandle)
MSDN ReferenceCloses a cursor that has been opened on a statement and discards pending results.
-
SQLCancel
public static short SQLCancel(long StatementHandle)
MSDN ReferenceCancels the processing on a statement.
To cancel processing on a connection or statement, use
CancelHandlefunction.
-
SQLCancelHandle
public static short SQLCancelHandle(short HandleType, long Handle)MSDN ReferenceCancels the processing on a connection or statement. The Driver Manager maps a call to SQLCancelHandle to a call to
CancelwhenHandleTypeisHANDLE_STMT.- Parameters:
HandleType- one of:HANDLE_DBCHANDLE_STMT- Since:
- ODBC 3.8
-
SQLEndTran
public static short SQLEndTran(short HandleType, long Handle, short CompletionType)MSDN ReferenceRequests a commit or rollback operation for all active operations on all statements associated with a connection. SQLEndTran can also request that a commit or rollback operation be performed for all connections associated with an environment.
- Parameters:
HandleType- one of:HANDLE_ENVHANDLE_DBCCompletionType- one of:COMMITROLLBACK
-
SQLDisconnect
public static short SQLDisconnect(long ConnectionHandle)
MSDN ReferenceCloses the connection associated with a specific connection handle.
- Parameters:
ConnectionHandle- the connection handle
-
SQLFreeHandle
public static short SQLFreeHandle(short HandleType, long Handle)MSDN ReferenceFrees resources associated with a specific environment, connection, statement, or descriptor handle.
- Parameters:
HandleType- one of:HANDLE_ENVHANDLE_DBCHANDLE_STMTHANDLE_DESCHANDLE_SENV
-
nSQLCompleteAsync
public static short nSQLCompleteAsync(short HandleType, long Handle, long AsyncRetCodePtr)Unsafe version of:CompleteAsync
-
SQLCompleteAsync
public static short SQLCompleteAsync(short HandleType, long Handle, java.nio.ShortBuffer AsyncRetCodePtr)SQLCompleteAsync can be used to determine when an asynchronous function is complete using either notification- or polling-based processing. For more information about asynchronous operations, see Asynchronous Execution.SQLCompleteAsync is only implemented in the ODBC Driver Manager.
In notification based asynchronous processing mode, SQLCompleteAsync must be called after the Driver Manager raises the event object used for notification. SQLCompleteAsync completes the asynchronous processing and the asynchronous function will generate a return code.
In polling based asynchronous processing mode, SQLCompleteAsync is an alternative to calling the original asynchronous function, without needing to specify the arguments in the original asynchronous function call. SQLCompleteAsync can be used regardless whether the ODBC Cursor Library is enabled.
- Parameters:
HandleType- the type of the handle on which to complete asynchronous processing. One of:HANDLE_DBCHANDLE_STMTHandle- the handle on which to complete asynchronous processing. IfHandleis not a valid handle of the type specified byHandleType, SQLCompleteAsync returnsINVALID_HANDLE.AsyncRetCodePtr- pointer to a buffer that will contain the return code of the asynchronous API. IfAsyncRetCodePtrisNULL, SQLCompleteAsync returnsERROR.- Since:
- ODBC 3.8
-
nSQLColumns
public static short nSQLColumns(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long ColumnName, short NameLength4)
-
SQLColumns
public static short SQLColumns(long StatementHandle, @Nullable java.nio.ByteBuffer CatalogName, @Nullable java.nio.ByteBuffer SchemaName, @Nullable java.nio.ByteBuffer TableName, @Nullable java.nio.ByteBuffer ColumnName)
-
nSQLSpecialColumns
public static short nSQLSpecialColumns(long StatementHandle, short IdentifierType, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Scope, short Nullable)
-
SQLSpecialColumns
public static short SQLSpecialColumns(long StatementHandle, short IdentifierType, @Nullable java.nio.ByteBuffer CatalogName, @Nullable java.nio.ByteBuffer SchemaName, @Nullable java.nio.ByteBuffer TableName, short Scope, short Nullable)
-
nSQLStatistics
public static short nSQLStatistics(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Unique, short Reserved)
-
SQLStatistics
public static short SQLStatistics(long StatementHandle, @Nullable java.nio.ByteBuffer CatalogName, @Nullable java.nio.ByteBuffer SchemaName, @Nullable java.nio.ByteBuffer TableName, short Unique, short Reserved)
-
nSQLTables
public static short nSQLTables(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long TableType, short NameLength4)
-
SQLTables
public static short SQLTables(long StatementHandle, @Nullable java.nio.ByteBuffer CatalogName, @Nullable java.nio.ByteBuffer SchemaName, @Nullable java.nio.ByteBuffer TableName, @Nullable java.nio.ByteBuffer TableType)
-
SQLTransact
public static short SQLTransact(long EnvironmentHandle, long ConnectionHandle, short CompletionType)- Parameters:
ConnectionHandle- the connection handle
-
nSQLDriverConnect
public static short nSQLDriverConnect(long ConnectionHandle, long WindowHandle, long InConnectionString, short StringLength1, long OutConnectionString, short BufferLength, long StringLength2Ptr, short DriverCompletion)Unsafe version of:DriverConnect- Parameters:
StringLength1- the length of*InConnectionString, in charactersBufferLength- length of the*OutConnectionStringbuffer, in characters.
-
SQLDriverConnect
public static short SQLDriverConnect(long ConnectionHandle, long WindowHandle, java.nio.ByteBuffer InConnectionString, @Nullable java.nio.ByteBuffer OutConnectionString, @Nullable java.nio.ShortBuffer StringLength2Ptr, short DriverCompletion) public static short SQLDriverConnect(long ConnectionHandle, long WindowHandle, java.lang.CharSequence InConnectionString, @Nullable java.nio.ByteBuffer OutConnectionString, @Nullable java.nio.ShortBuffer StringLength2Ptr, short DriverCompletion)MSDN ReferenceSQLDriverConnect is an alternative to
Connect. It supports data sources that require more connection information than the three arguments in SQLConnect, dialog boxes to prompt the user for all connection information, and data sources that are not defined in the system information.SQLDriverConnect provides the following connection attributes:
- Establish a connection using a connection string that contains the data source name, one or more user IDs, one or more passwords, and other information required by the data source.
- Establish a connection using a partial connection string or no additional information; in this case, the Driver Manager and the driver can each prompt the user for connection information.
- Establish a connection to a data source that is not defined in the system information. If the application supplies a partial connection string, the driver can prompt the user for connection information.
- Establish a connection to a data source using a connection string constructed from the information in a .dsn file.
After a connection is established, SQLDriverConnect returns the completed connection string. The application can use this string for subsequent connection requests.
- Parameters:
ConnectionHandle- the connection handleWindowHandle- the window handle. The application can pass the handle of the parent window, if applicable, or a null pointer if either the window handle is not applicable or SQLDriverConnect will not present any dialog boxes.InConnectionString- a full connection string, a partial connection string, or an empty string.OutConnectionString- pointer to a buffer for the completed connection string. Upon successful connection to the target data source, this buffer contains the completed connection string. Applications should allocate at least 1,024 characters for this buffer. IfOutConnectionStringisNULL,StringLength2Ptrwill still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to byOutConnectionString.StringLength2Ptr- pointer to a buffer in which to return the total number of characters (excluding the null-termination character) available to return in*OutConnectionString. If the number of characters available to return is greater than or equal toBufferLength, the completed connection string in*OutConnectionStringis truncated toBufferLengthminus the length of a null-termination character.DriverCompletion- a flag that indicates whether the Driver Manager or driver must prompt for more connection information. One of:DRIVER_NOPROMPTDRIVER_COMPLETEDRIVER_PROMPTDRIVER_COMPLETE_REQUIRED- Returns:
SUCCESS,SUCCESS_WITH_INFO,NO_DATA,ERROR,INVALID_HANDLE, orSTILL_EXECUTING
-
nSQLBrowseConnect
public static short nSQLBrowseConnect(long ConnectionHandle, long InConnectionString, short StringLength1, long OutConnectionString, short BufferLength, long StringLength2Ptr)Unsafe version of:BrowseConnect- Parameters:
StringLength1- the length of*InConnectionString, in charactersBufferLength- length of the*OutConnectionStringbuffer, in characters.
-
SQLBrowseConnect
public static short SQLBrowseConnect(long ConnectionHandle, java.nio.ByteBuffer InConnectionString, @Nullable java.nio.ByteBuffer OutConnectionString, @Nullable java.nio.ShortBuffer StringLength2Ptr) public static short SQLBrowseConnect(long ConnectionHandle, java.lang.CharSequence InConnectionString, @Nullable java.nio.ByteBuffer OutConnectionString, @Nullable java.nio.ShortBuffer StringLength2Ptr)MSDN ReferenceSupports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source. Each call to SQLBrowseConnect returns successive levels of attributes and attribute values. When all levels have been enumerated, a connection to the data source is completed and a complete connection string is returned by SQLBrowseConnect. A return code of
SUCCESSorSUCCESS_WITH_INFOindicates that all connection information has been specified and the application is now connected to the data source.- Parameters:
ConnectionHandle- the connection handleInConnectionString- browse request connection stringOutConnectionString- pointer to a character buffer in which to return the browse result connection string. IfOutConnectionStringisNULL,StringLength2Ptrwill still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to byOutConnectionString.StringLength2Ptr- pointer to a buffer in which to return the total number of characters (excluding the null-termination character) available to return in*OutConnectionString. If the number of characters available to return is greater than or equal toBufferLength, the completed connection string in*OutConnectionStringis truncated toBufferLengthminus the length of a null-termination character.- Returns:
SUCCESS,SUCCESS_WITH_INFO,NEED_DATA,ERROR,INVALID_HANDLE, orSTILL_EXECUTING
-
SQLBulkOperations
public static short SQLBulkOperations(long StatementHandle, short Operation)MSDN ReferencePerforms bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.
- Parameters:
Operation- one of:ADDSETPOS_MAX_OPTION_VALUEUPDATE_BY_BOOKMARKDELETE_BY_BOOKMARKFETCH_BY_BOOKMARK
-
nSQLColumnPrivileges
public static short nSQLColumnPrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName, long szColumnName, short cchColumnName)
-
SQLColumnPrivileges
public static short SQLColumnPrivileges(long hstmt, @Nullable java.nio.ByteBuffer szCatalogName, @Nullable java.nio.ByteBuffer szSchemaName, @Nullable java.nio.ByteBuffer szTableName, @Nullable java.nio.ByteBuffer szColumnName)
-
nSQLDescribeParam
public static short nSQLDescribeParam(long StatementHandle, short ParameterNumber, long DataTypePtr, long ParameterSizePtr, long DecimalDigitsPtr, long NullablePtr)Unsafe version of:DescribeParam
-
SQLDescribeParam
public static short SQLDescribeParam(long StatementHandle, short ParameterNumber, @Nullable java.nio.ShortBuffer DataTypePtr, @Nullable PointerBuffer ParameterSizePtr, @Nullable java.nio.ShortBuffer DecimalDigitsPtr, @Nullable java.nio.ShortBuffer NullablePtr)MSDN ReferenceReturns the description of a parameter marker associated with a prepared SQL statement. This information is also available in the fields of the IPD.
-
nSQLExtendedFetch
public static short nSQLExtendedFetch(long hstmt, short fFetchType, long irow, long pcrow, long rgfRowStatus)
-
SQLExtendedFetch
public static short SQLExtendedFetch(long hstmt, short fFetchType, long irow, @Nullable PointerBuffer pcrow, @Nullable java.nio.ShortBuffer rgfRowStatus)
-
nSQLForeignKeys
public static short nSQLForeignKeys(long hstmt, long szPkCatalogName, short cchPkCatalogName, long szPkSchemaName, short cchPkSchemaName, long szPkTableName, short cchPkTableName, long szFkCatalogName, short cchFkCatalogName, long szFkSchemaName, short cchFkSchemaName, long szFkTableName, short cchFkTableName)
-
SQLForeignKeys
public static short SQLForeignKeys(long hstmt, @Nullable java.nio.ByteBuffer szPkCatalogName, @Nullable java.nio.ByteBuffer szPkSchemaName, @Nullable java.nio.ByteBuffer szPkTableName, @Nullable java.nio.ByteBuffer szFkCatalogName, @Nullable java.nio.ByteBuffer szFkSchemaName, @Nullable java.nio.ByteBuffer szFkTableName)
-
SQLMoreResults
public static short SQLMoreResults(long StatementHandle)
MSDN ReferenceDetermines whether more results are available on a statement containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initializes processing for those results.
-
nSQLNativeSql
public static short nSQLNativeSql(long ConnectionHandle, long InStatementText, int TextLength1, long OutStatementText, int BufferLength, long TextLength2Ptr)Unsafe version of:NativeSql
-
SQLNativeSql
public static short SQLNativeSql(long ConnectionHandle, java.nio.ByteBuffer InStatementText, @Nullable java.nio.ByteBuffer OutStatementText, java.nio.IntBuffer TextLength2Ptr) public static short SQLNativeSql(long ConnectionHandle, java.lang.CharSequence InStatementText, @Nullable java.nio.ByteBuffer OutStatementText, java.nio.IntBuffer TextLength2Ptr)MSDN ReferenceReturns the SQL string as modified by the driver. SQLNativeSql does not execute the SQL statement.
- Parameters:
ConnectionHandle- the connection handle
-
nSQLNumParams
public static short nSQLNumParams(long StatementHandle, long ParameterCountPtr)Unsafe version of:NumParams
-
SQLNumParams
public static short SQLNumParams(long StatementHandle, @Nullable java.nio.ShortBuffer ParameterCountPtr)MSDN ReferenceReturns the number of parameters in an SQL statement.
-
nSQLParamOptions
public static short nSQLParamOptions(long hstmt, long crow, long pirow)
-
SQLParamOptions
public static short SQLParamOptions(long hstmt, long crow, PointerBuffer pirow)
-
nSQLPrimaryKeys
public static short nSQLPrimaryKeys(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)
-
SQLPrimaryKeys
public static short SQLPrimaryKeys(long hstmt, @Nullable java.nio.ByteBuffer szCatalogName, @Nullable java.nio.ByteBuffer szSchemaName, @Nullable java.nio.ByteBuffer szTableName)
-
nSQLProcedureColumns
public static short nSQLProcedureColumns(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName, long szColumnName, short cchColumnName)
-
SQLProcedureColumns
public static short SQLProcedureColumns(long hstmt, @Nullable java.nio.ByteBuffer szCatalogName, @Nullable java.nio.ByteBuffer szSchemaName, @Nullable java.nio.ByteBuffer szProcName, @Nullable java.nio.ByteBuffer szColumnName)
-
nSQLProcedures
public static short nSQLProcedures(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName)
-
SQLProcedures
public static short SQLProcedures(long hstmt, @Nullable java.nio.ByteBuffer szCatalogName, @Nullable java.nio.ByteBuffer szSchemaName, @Nullable java.nio.ByteBuffer szProcName)
-
SQLSetPos
public static short SQLSetPos(long StatementHandle, long RowNumber, short Operation, short LockType)MSDN ReferenceSets the cursor position in a rowset and allows an application to refresh data in the rowset or to update or delete data in the result set.
- Parameters:
Operation- one of:POSITIONREFRESHUPDATEDELETELockType- one of:LOCK_NO_CHANGELOCK_EXCLUSIVELOCK_UNLOCKSETPOS_MAX_LOCK_VALUE
-
nSQLTablePrivileges
public static short nSQLTablePrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)
-
SQLTablePrivileges
public static short SQLTablePrivileges(long hstmt, @Nullable java.nio.ByteBuffer szCatalogName, @Nullable java.nio.ByteBuffer szSchemaName, @Nullable java.nio.ByteBuffer szTableName)
-
nSQLDrivers
public static short nSQLDrivers(long EnvironmentHandle, short Direction, long DriverDescription, short BufferLength1, long DescriptionLengthPtr, long DriverAttributes, short BufferLength2, long AttributesLengthPtr)Unsafe version of:Drivers
-
SQLDrivers
public static short SQLDrivers(long EnvironmentHandle, short Direction, @Nullable java.nio.ByteBuffer DriverDescription, @Nullable java.nio.ShortBuffer DescriptionLengthPtr, @Nullable java.nio.ByteBuffer DriverAttributes, @Nullable java.nio.ShortBuffer AttributesLengthPtr)MSDN ReferenceLists driver descriptions and driver attribute keywords. This function is implemented only by the Driver Manager.
-
nSQLBindParameter
public static short nSQLBindParameter(long StatementHandle, short ParameterNumber, short InputOutputType, short ValueType, short ParameterType, long ColumnSize, short DecimalDigits, long ParameterValuePtr, long BufferLength, long StrLen_or_IndPtr)Unsafe version of:BindParameter
-
SQLBindParameter
public static short SQLBindParameter(long StatementHandle, short ParameterNumber, short InputOutputType, short ValueType, short ParameterType, long ColumnSize, short DecimalDigits, @Nullable java.nio.ByteBuffer ParameterValuePtr, @Nullable PointerBuffer StrLen_or_IndPtr)MSDN ReferenceBinds a buffer to a parameter marker in an SQL statement. SQLBindParameter supports binding to a Unicode C data type, even if the underlying driver does not support Unicode data.
-
nSQLAllocHandleStd
public static short nSQLAllocHandleStd(short fHandleType, long hInput, long phOutput)
-
SQLAllocHandleStd
public static short SQLAllocHandleStd(short fHandleType, long hInput, PointerBuffer phOutput)
-
-