Top Description Inners Fields Constructors Methods
org.lwjgl.odbc

public Class SQL

extends Object
Class Inheritance
Imports
javax.annotation.*, java.nio.*, org.lwjgl.*, org.lwjgl.system.*

Native 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 and Inner Type Summary

Modifier and TypeClass and Description
public static class
SQL.Functions

Contains the function pointers loaded from the odbc SharedLibrary.

Field Summary

Modifier and TypeField and Description
private static final SharedLibrary
public static final short
public static final short
public static final int
SQL_ACCESSIBLE_PROCEDURES

Information requested by GetInfo:

public static final int
SQL_ACCESSIBLE_TABLES

Information requested by GetInfo:

public static final short
public static final short
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_ADD

Operations in BulkOperations.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final String
public static final short
public static final String
SQL_ALL_SCHEMAS

Defines for Tables.

public static final String
public static final short
SQL_ALL_TYPES

GetTypeInfo() request for all data types.

public static final short
SQL_ALTER_DOMAIN

Info types for GetInfo.

public static final int
SQL_ALTER_TABLE

Information requested by GetInfo:

public static final short
public static final short
SQL_AM_NONE

Bitmasks for ASYNC_MODE.

public static final short
public static final short
SQL_APD_TYPE

SQLSQLLEN GetData code indicating that the application row descriptor specifies the data type.

public static final int
SQL_API_ODBC3_ALL_FUNCTIONS

This returns a bitmap, which allows us to handle the higher-valued function numbers.

public static final int
SQL_API_ODBC3_ALL_FUNCTIONS_SIZE

This returns a bitmap, which allows us to handle the higher-valued function numbers.

public static final int
SQL_API_SQLALLOCCONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLALLOCENV

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLALLOCHANDLE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLALLOCHANDLESTD

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLALLOCSTMT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLBINDCOL

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLBINDPARAM

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLBINDPARAMETER

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLBROWSECONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLBULKOPERATIONS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCANCEL

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCANCELHANDLE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCLOSECURSOR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOLATTRIBUTE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOLATTRIBUTES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOLUMNPRIVILEGES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOLUMNS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOMPLETEASYNC

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLCOPYDESC

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDATASOURCES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDESCRIBECOL

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDESCRIBEPARAM

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDISCONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDRIVERCONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLDRIVERS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLENDTRAN

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLERROR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLEXECDIRECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLEXECUTE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLEXTENDEDFETCH

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFETCH

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFETCHSCROLL

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFOREIGNKEYS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFREECONNECT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFREEENV

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFREEHANDLE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLFREESTMT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETCONNECTATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETCONNECTOPTION

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETCURSORNAME

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETDATA

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETDESCFIELD

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETDESCREC

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETDIAGFIELD

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETDIAGREC

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETENVATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETFUNCTIONS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETINFO

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETSTMTATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETSTMTOPTION

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLGETTYPEINFO

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLMORERESULTS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLNATIVESQL

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLNUMPARAMS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLNUMRESULTCOLS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPARAMDATA

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPARAMOPTIONS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPREPARE

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPRIMARYKEYS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPROCEDURECOLUMNS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPROCEDURES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLPUTDATA

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLROWCOUNT

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETCONNECTATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETCONNECTOPTION

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETCURSORNAME

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETDESCFIELD

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETDESCREC

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETENVATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETPARAM

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETPOS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETSCROLLOPTIONS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETSTMTATTR

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSETSTMTOPTION

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSPECIALCOLUMNS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLSTATISTICS

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLTABLEPRIVILEGES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLTABLES

GetFunctions values to identify ODBC APIs.

public static final int
SQL_API_SQLTRANSACT

GetFunctions values to identify ODBC APIs.

public static final short
SQL_ARD_TYPE

SQLSQLLEN GetData code indicating that the application row descriptor specifies the data type.

public static final int
public static final short
public static final short
public static final short
public static final short
public static final int
public static final short
public static final short
public static final short
public static final short
SQL_ASYNC_MODE

Info types for GetInfo.

public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
SQL_ATTR_ACCESS_MODE

Connection attributes.

public static final int
SQL_ATTR_ANSI_APP

Connection attributes.

public static final int
SQL_ATTR_APP_PARAM_DESC

Statement attributes.

public static final int
SQL_ATTR_APP_ROW_DESC

Statement attributes.

public static final int
SQL_ATTR_ASYNC_DBC_EVENT

Connection attributes.

public static final int
public static final int
SQL_ATTR_ASYNC_ENABLE

Statement attributes.

public static final int
SQL_ATTR_ASYNC_STMT_EVENT

Statement attributes.

public static final int
SQL_ATTR_AUTO_IPD

Connection attributes.

public static final int
SQL_ATTR_AUTOCOMMIT

Connection attributes.

public static final int
SQL_ATTR_CONCURRENCY

Statement attributes.

public static final int
SQL_ATTR_CONNECTION_DEAD

Connection attributes.

public static final int
SQL_ATTR_CONNECTION_POOLING

Environment attributes.

public static final int
SQL_ATTR_CONNECTION_TIMEOUT

Connection attributes.

public static final int
SQL_ATTR_CP_MATCH

Environment attributes.

public static final int
SQL_ATTR_CURRENT_CATALOG

Connection attributes.

public static final int
SQL_ATTR_CURSOR_SCROLLABLE

Statement attributes.

public static final int
SQL_ATTR_CURSOR_SENSITIVITY

Statement attributes.

public static final int
SQL_ATTR_CURSOR_TYPE

Statement attributes.

public static final int
SQL_ATTR_DISCONNECT_BEHAVIOR

Connection attributes.

public static final int
SQL_ATTR_ENABLE_AUTO_IPD

Statement attributes.

public static final int
SQL_ATTR_ENLIST_IN_DTC

Connection attributes.

public static final int
SQL_ATTR_ENLIST_IN_XA

Connection attributes.

public static final int
SQL_ATTR_FETCH_BOOKMARK_PTR

Statement attributes.

public static final int
SQL_ATTR_IMP_PARAM_DESC

Statement attributes.

public static final int
SQL_ATTR_IMP_ROW_DESC

Statement attributes.

public static final int
SQL_ATTR_KEYSET_SIZE

Statement attributes.

public static final int
SQL_ATTR_LOGIN_TIMEOUT

Connection attributes.

public static final int
SQL_ATTR_MAX_LENGTH

Statement attributes.

public static final int
SQL_ATTR_MAX_ROWS

Statement attributes.

public static final int
SQL_ATTR_METADATA_ID

Connection attributes.

public static final int
SQL_ATTR_NOSCAN

Statement attributes.

public static final int
SQL_ATTR_ODBC_CURSORS

Connection attributes.

public static final int
SQL_ATTR_ODBC_VERSION

Environment attributes.

public static final int
SQL_ATTR_OUTPUT_NTS

Environment attributes.

public static final int
SQL_ATTR_PACKET_SIZE

Connection attributes.

public static final int
SQL_ATTR_PARAM_BIND_OFFSET_PTR

Statement attributes.

public static final int
SQL_ATTR_PARAM_BIND_TYPE

Statement attributes.

public static final int
SQL_ATTR_PARAM_OPERATION_PTR

Statement attributes.

public static final int
SQL_ATTR_PARAM_STATUS_PTR

Statement attributes.

public static final int
SQL_ATTR_PARAMS_PROCESSED_PTR

Statement attributes.

public static final int
SQL_ATTR_PARAMSET_SIZE

Statement attributes.

public static final int
SQL_ATTR_QUERY_TIMEOUT

Statement attributes.

public static final int
SQL_ATTR_QUIET_MODE

Connection attributes.

public static final short
public static final short
public static final int
SQL_ATTR_RESET_CONNECTION

Connection attributes.

public static final int
SQL_ATTR_RETRIEVE_DATA

Statement attributes.

public static final int
SQL_ATTR_ROW_ARRAY_SIZE

Statement attributes.

public static final int
SQL_ATTR_ROW_BIND_OFFSET_PTR

Statement attributes.

public static final int
SQL_ATTR_ROW_BIND_TYPE

Statement attributes.

public static final int
SQL_ATTR_ROW_NUMBER

Statement attributes.

public static final int
SQL_ATTR_ROW_OPERATION_PTR

Statement attributes.

public static final int
SQL_ATTR_ROW_STATUS_PTR

Statement attributes.

public static final int
SQL_ATTR_ROWS_FETCHED_PTR

Statement attributes.

public static final int
SQL_ATTR_SIMULATE_CURSOR

Statement attributes.

public static final int
SQL_ATTR_TRACE

Connection attributes.

public static final int
SQL_ATTR_TRACEFILE

Connection attributes.

public static final int
SQL_ATTR_TRANSLATE_LIB

Connection attributes.

public static final int
SQL_ATTR_TRANSLATE_OPTION

Connection attributes.

public static final int
SQL_ATTR_TXN_ISOLATION

Connection attributes.

public static final int
SQL_ATTR_USE_BOOKMARKS

Statement attributes.

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_BATCH_SUPPORT

Info types for GetInfo.

public static final short
SQL_BEST_ROWID

Column types and scopes in SpecialColumns.

public static final short
SQL_BIGINT

SQL extended datatypes.

public static final short
SQL_BINARY

SQL extended datatypes.

public static final short
public static final short
public static final short
SQL_BIT

SQL extended datatypes.

public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_C_BINARY

C datatype to SQL datatype mapping.

public static final short
SQL_C_BIT

C datatype to SQL datatype mapping.

public static final short
SQL_C_BOOKMARK

C datatype to SQL datatype mapping.

public static final short
SQL_C_CHAR

C datatype to SQL datatype mapping.

public static final short
SQL_C_DATE

C datatype to SQL datatype mapping.

public static final short
SQL_C_DEFAULT

C datatype to SQL datatype mapping.

public static final short
SQL_C_DOUBLE

C datatype to SQL datatype mapping.

public static final short
SQL_C_FLOAT

C datatype to SQL datatype mapping.

public static final short
SQL_C_GUID

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_DAY

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_DAY_TO_HOUR

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_DAY_TO_MINUTE

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_DAY_TO_SECOND

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_HOUR

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_HOUR_TO_MINUTE

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_HOUR_TO_SECOND

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_MINUTE

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_MINUTE_TO_SECOND

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_MONTH

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_SECOND

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_YEAR

C datatype to SQL datatype mapping.

public static final short
SQL_C_INTERVAL_YEAR_TO_MONTH

C datatype to SQL datatype mapping.

public static final short
SQL_C_LONG

C datatype to SQL datatype mapping.

public static final short
SQL_C_NUMERIC

C datatype to SQL datatype mapping.

public static final short
SQL_C_SBIGINT

C datatype to SQL datatype mapping.

public static final short
SQL_C_SHORT

C datatype to SQL datatype mapping.

public static final short
SQL_C_SLONG

C datatype to SQL datatype mapping.

public static final short
SQL_C_SSHORT

C datatype to SQL datatype mapping.

public static final short
SQL_C_STINYINT

C datatype to SQL datatype mapping.

public static final short
SQL_C_TIME

C datatype to SQL datatype mapping.

public static final short
SQL_C_TIMESTAMP

C datatype to SQL datatype mapping.

public static final short
SQL_C_TINYINT

C datatype to SQL datatype mapping.

public static final short
SQL_C_TYPE_DATE

C datatype to SQL datatype mapping.

public static final short
SQL_C_TYPE_TIME

C datatype to SQL datatype mapping.

public static final short
SQL_C_TYPE_TIMESTAMP

C datatype to SQL datatype mapping.

public static final short
SQL_C_UBIGINT

C datatype to SQL datatype mapping.

public static final short
SQL_C_ULONG

C datatype to SQL datatype mapping.

public static final short
SQL_C_USHORT

C datatype to SQL datatype mapping.

public static final short
SQL_C_UTINYINT

C datatype to SQL datatype mapping.

public static final short
SQL_C_VARBOOKMARK

C datatype to SQL datatype mapping.

public static final short
SQL_C_WCHAR

WCHAR definitions.

public static final int
SQL_CA1_ABSOLUTE

Supported FetchScroll FetchOrientation's.

public static final int
SQL_CA1_BOOKMARK

Supported FetchScroll FetchOrientation's.

public static final int
SQL_CA1_BULK_ADD

Supported BulkOperations operations.

public static final int
public static final int
public static final int
public static final int
SQL_CA1_LOCK_EXCLUSIVE

Supported SetPos LockType's.

public static final int
SQL_CA1_LOCK_NO_CHANGE

Supported SetPos LockType's.

public static final int
SQL_CA1_LOCK_UNLOCK

Supported SetPos LockType's.

public static final int
SQL_CA1_NEXT

Supported FetchScroll FetchOrientation's.

public static final int
SQL_CA1_POS_DELETE

Supported SetPos Operations.

public static final int
SQL_CA1_POS_POSITION

Supported SetPos Operations.

public static final int
SQL_CA1_POS_REFRESH

Supported SetPos Operations.

public static final int
SQL_CA1_POS_UPDATE

Supported SetPos Operations.

public static final int
SQL_CA1_POSITIONED_DELETE

Positioned updates and deletes.

public static final int
SQL_CA1_POSITIONED_UPDATE

Positioned updates and deletes.

public static final int
SQL_CA1_RELATIVE

Supported FetchScroll FetchOrientation's.

public static final int
SQL_CA1_SELECT_FOR_UPDATE

Positioned updates and deletes.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
SQL_CA2_SENSITIVITY_ADDITIONS

Sensitivity of the cursor to its own inserts, deletes, and updates.

public static final int
SQL_CA2_SENSITIVITY_DELETIONS

Sensitivity of the cursor to its own inserts, deletes, and updates.

public static final int
SQL_CA2_SENSITIVITY_UPDATES

Sensitivity of the cursor to its own inserts, deletes, and updates.

public static final int
SQL_CA2_SIMULATE_NON_UNIQUE

The kinds of positioned statements that can be simulated.

public static final int
SQL_CA2_SIMULATE_TRY_UNIQUE

The kinds of positioned statements that can be simulated.

public static final int
SQL_CA2_SIMULATE_UNIQUE

The kinds of positioned statements that can be simulated.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_CASCADE

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
public static final int
SQL_CATALOG_NAME

Information requested by GetInfo:

public static final short
public static final short
SQL_CATALOG_TERM

Info types for GetInfo.

public static final short
SQL_CATALOG_USAGE

Info types for GetInfo.

public static final short
public static final short
public static final int
public static final int
public static final short
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_CHAR

SQL data type codes.

public static final int
public static final int
public static final short
public static final int
public static final int
public static final int
public static final short
SQL_CODE_DATE

SQL date/time type subcodes.

public static final short
SQL_CODE_DAY

Interval code.

public static final short
SQL_CODE_DAY_TO_HOUR

Interval code.

public static final short
SQL_CODE_DAY_TO_MINUTE

Interval code.

public static final short
SQL_CODE_DAY_TO_SECOND

Interval code.

public static final short
SQL_CODE_HOUR

Interval code.

public static final short
public static final short
public static final short
SQL_CODE_MINUTE

Interval code.

public static final short
public static final short
SQL_CODE_MONTH

Interval code.

public static final short
SQL_CODE_SECOND

Interval code.

public static final short
SQL_CODE_TIME

SQL date/time type subcodes.

public static final short
SQL_CODE_TIMESTAMP

SQL date/time type subcodes.

public static final short
SQL_CODE_YEAR

Interval code.

public static final short
SQL_CODE_YEAR_TO_MONTH

Interval code.

public static final short
SQL_COL_PRED_BASIC

New defines for SEARCHABLE column in GetTypeInfo.

public static final short
SQL_COL_PRED_CHAR

New defines for SEARCHABLE column in GetTypeInfo.

public static final short
public static final short
public static final int
SQL_COLLATION_SEQ

Information requested by GetInfo:

public static final short
SQL_COLUMN_ALIAS

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_CONVERT_BIGINT

Info types for GetInfo.

public static final short
SQL_CONVERT_BINARY

Info types for GetInfo.

public static final short
SQL_CONVERT_BIT

Info types for GetInfo.

public static final short
SQL_CONVERT_CHAR

Info types for GetInfo.

public static final short
SQL_CONVERT_DATE

Info types for GetInfo.

public static final short
public static final short
SQL_CONVERT_DOUBLE

Info types for GetInfo.

public static final short
SQL_CONVERT_FLOAT

Info types for GetInfo.

public static final short
public static final short
SQL_CONVERT_GUID

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_CONVERT_REAL

Info types for GetInfo.

public static final short
public static final short
SQL_CONVERT_TIME

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
SQL_CONVERT_WCHAR

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_CREATE_DOMAIN

Info types for GetInfo.

public static final short
SQL_CREATE_SCHEMA

Info types for GetInfo.

public static final short
SQL_CREATE_TABLE

Info types for GetInfo.

public static final short
public static final short
SQL_CREATE_VIEW

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final long
public static final long
public static final long
public static final long
public static final int
SQL_CURSOR_COMMIT_BEHAVIOR

Information requested by GetInfo:

public static final short
public static final short
public static final short
public static final short
public static final int
SQL_CURSOR_SENSITIVITY

Information requested by GetInfo:

public static final short
public static final short
public static final int
SQL_CV_CASCADED

VIEW values.

public static final int
SQL_CV_CHECK_OPTION

VIEW values.

public static final int
SQL_CV_CREATE_VIEW

VIEW values.

public static final int
SQL_CV_LOCAL

VIEW values.

public static final int
SQL_CVT_BIGINT

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_BINARY

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_BIT

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_CHAR

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_DATE

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_DECIMAL

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_DOUBLE

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_FLOAT

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_GUID

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_INTEGER

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_INTERVAL_DAY_TIME

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_INTERVAL_YEAR_MONTH

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_LONGVARBINARY

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_LONGVARCHAR

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_NUMERIC

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_REAL

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_SMALLINT

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_TIME

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_TIMESTAMP

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_TINYINT

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_VARBINARY

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_VARCHAR

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_WCHAR

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_WLONGVARCHAR

SQL_CONVERT_ return value bitmasks.

public static final int
SQL_CVT_WVARCHAR

SQL_CONVERT_ return value bitmasks.

public static final int
public static final short
SQL_DATA_AT_EXEC

Special length/indicator values.

public static final int
SQL_DATA_SOURCE_NAME

Information requested by GetInfo:

public static final int
SQL_DATA_SOURCE_READ_ONLY

Information requested by GetInfo:

public static final short
SQL_DATE

SQL extended datatypes.

public static final short
SQL_DATE_LEN

Date/time length constants.

public static final short
SQL_DATETIME

SQL data type codes.

public static final short
public static final short
public static final short
public static final short
public static final int
SQL_DBMS_NAME

Information requested by GetInfo:

public static final int
SQL_DBMS_VER

Information requested by GetInfo:

public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_DDL_INDEX

Info types for GetInfo.

public static final short
SQL_DECIMAL

SQL data type codes.

public static final short
SQL_DEFAULT

Default conversion code for BindCol, BindParameter and GetData.

public static final short
public static final int
SQL_DEFAULT_TXN_ISOLATION

Information requested by GetInfo:

public static final short
SQL_DELETE

Operations in SetPos.

public static final short
public static final short
SQL_DESC_ALLOC_AUTO

Values of DESC_ALLOC_TYPE field in descriptor.

public static final short
SQL_DESC_ALLOC_TYPE

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_ALLOC_USER

Values of DESC_ALLOC_TYPE field in descriptor.

public static final short
SQL_DESC_ARRAY_SIZE

Extended descriptor field.

public static final short
SQL_DESC_ARRAY_STATUS_PTR

Extended descriptor field.

public static final short
SQL_DESC_AUTO_UNIQUE_VALUE

Extended descriptor field.

public static final short
SQL_DESC_BASE_COLUMN_NAME

Extended descriptor field.

public static final short
SQL_DESC_BASE_TABLE_NAME

Extended descriptor field.

public static final short
SQL_DESC_BIND_OFFSET_PTR

Extended descriptor field.

public static final short
SQL_DESC_BIND_TYPE

Extended descriptor field.

public static final short
SQL_DESC_CASE_SENSITIVE

Extended descriptor field.

public static final short
SQL_DESC_CATALOG_NAME

Extended descriptor field.

public static final short
SQL_DESC_CONCISE_TYPE

Extended descriptor field.

public static final short
SQL_DESC_COUNT

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_DATA_PTR

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_DATETIME_INTERVAL_CODE

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_DATETIME_INTERVAL_PRECISION

Extended descriptor field.

public static final short
SQL_DESC_DISPLAY_SIZE

Extended descriptor field.

public static final short
SQL_DESC_FIXED_PREC_SCALE

Extended descriptor field.

public static final short
SQL_DESC_INDICATOR_PTR

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_LABEL

Extended descriptor field.

public static final short
SQL_DESC_LENGTH

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_LITERAL_PREFIX

Extended descriptor field.

public static final short
SQL_DESC_LITERAL_SUFFIX

Extended descriptor field.

public static final short
SQL_DESC_LOCAL_TYPE_NAME

Extended descriptor field.

public static final short
SQL_DESC_MAXIMUM_SCALE

Extended descriptor field.

public static final short
SQL_DESC_MINIMUM_SCALE

Extended descriptor field.

public static final short
SQL_DESC_NAME

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_NULLABLE

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_NUM_PREC_RADIX

Extended descriptor field.

public static final short
SQL_DESC_OCTET_LENGTH

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_OCTET_LENGTH_PTR

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_PARAMETER_TYPE

Extended descriptor field.

public static final short
SQL_DESC_PRECISION

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_ROWS_PROCESSED_PTR

Extended descriptor field.

public static final short
SQL_DESC_ROWVER

Extended descriptor field.

public static final short
SQL_DESC_SCALE

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_SCHEMA_NAME

Extended descriptor field.

public static final short
SQL_DESC_SEARCHABLE

Extended descriptor field.

public static final short
SQL_DESC_TABLE_NAME

Extended descriptor field.

public static final short
SQL_DESC_TYPE

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_TYPE_NAME

Extended descriptor field.

public static final short
SQL_DESC_UNNAMED

Identifiers of fields in the SQL descriptor.

public static final short
SQL_DESC_UNSIGNED

Extended descriptor field.

public static final short
SQL_DESC_UPDATABLE

Extended descriptor field.

public static final int
SQL_DESCRIBE_PARAMETER

Information requested by GetInfo:

public static final int
public static final int
public static final short
SQL_DIAG_ALTER_DOMAIN

Dynamic function codes.

public static final short
SQL_DIAG_ALTER_TABLE

Dynamic function codes.

public static final short
SQL_DIAG_CALL

Dynamic function codes.

public static final short
SQL_DIAG_CLASS_ORIGIN

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_COLUMN_NUMBER

Defines for diagnostics fields.

public static final short
SQL_DIAG_CONNECTION_NAME

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_CREATE_ASSERTION

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_CHARACTER_SET

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_COLLATION

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_DOMAIN

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_INDEX

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_SCHEMA

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_TABLE

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_TRANSLATION

Dynamic function codes.

public static final short
SQL_DIAG_CREATE_VIEW

Dynamic function codes.

public static final short
SQL_DIAG_CURSOR_ROW_COUNT

Defines for diagnostics fields.

public static final short
SQL_DIAG_DELETE_WHERE

Dynamic function codes.

public static final short
SQL_DIAG_DROP_ASSERTION

Dynamic function codes.

public static final short
SQL_DIAG_DROP_CHARACTER_SET

Dynamic function codes.

public static final short
SQL_DIAG_DROP_COLLATION

Dynamic function codes.

public static final short
SQL_DIAG_DROP_DOMAIN

Dynamic function codes.

public static final short
SQL_DIAG_DROP_INDEX

Dynamic function codes.

public static final short
SQL_DIAG_DROP_SCHEMA

Dynamic function codes.

public static final short
SQL_DIAG_DROP_TABLE

Dynamic function codes.

public static final short
SQL_DIAG_DROP_TRANSLATION

Dynamic function codes.

public static final short
SQL_DIAG_DROP_VIEW

Dynamic function codes.

public static final short
SQL_DIAG_DYNAMIC_DELETE_CURSOR

Dynamic function codes.

public static final short
SQL_DIAG_DYNAMIC_FUNCTION

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_DYNAMIC_FUNCTION_CODE

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_DYNAMIC_UPDATE_CURSOR

Dynamic function codes.

public static final short
SQL_DIAG_GRANT

Dynamic function codes.

public static final short
SQL_DIAG_INSERT

Dynamic function codes.

public static final short
SQL_DIAG_MESSAGE_TEXT

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_NATIVE

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_NUMBER

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_RETURNCODE

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_REVOKE

Dynamic function codes.

public static final short
SQL_DIAG_ROW_COUNT

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_ROW_NUMBER

Defines for diagnostics fields.

public static final short
SQL_DIAG_SELECT_CURSOR

Dynamic function codes.

public static final short
SQL_DIAG_SERVER_NAME

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_SQLSTATE

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_SUBCLASS_ORIGIN

Identifiers of fields in the diagnostics area.

public static final short
SQL_DIAG_UNKNOWN_STATEMENT

Dynamic function codes.

public static final short
SQL_DIAG_UPDATE_WHERE

Dynamic function codes.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_DM_VER

Info types for GetInfo.

public static final short
SQL_DOUBLE

SQL data type codes.

public static final int
public static final int
public static final short
public static final short
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.

public static final short
public static final short
public static final short
SQL_DRIVER_DESC_FIELD_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..

public static final short
SQL_DRIVER_DIAG_FIELD_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..

public static final short
SQL_DRIVER_HDBC

Info types for GetInfo.

public static final short
SQL_DRIVER_HDESC

Info types for GetInfo.

public static final short
SQL_DRIVER_HENV

Info types for GetInfo.

public static final short
SQL_DRIVER_HLIB

Info types for GetInfo.

public static final short
SQL_DRIVER_HSTMT

Info types for GetInfo.

public static final short
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..

public static final short
SQL_DRIVER_NAME

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
SQL_DRIVER_SQL_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..

public static final short
SQL_DRIVER_VER

Info types for GetInfo.

public static final short
public static final short
SQL_DROP_ASSERTION

Info types for GetInfo.

public static final short
public static final short
SQL_DROP_COLLATION

Info types for GetInfo.

public static final short
SQL_DROP_DOMAIN

Info types for GetInfo.

public static final short
SQL_DROP_SCHEMA

Info types for GetInfo.

public static final short
SQL_DROP_TABLE

Info types for GetInfo.

public static final short
public static final short
SQL_DROP_VIEW

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final int
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
SQL_ENSURE

Defines for Statistics.

public static final short
public static final short
SQL_ERROR

Return values from functions.

public static final short
public static final short
SQL_FALSE

CLI option values.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_FETCH_ABSOLUTE

Other codes used for FetchOrientation in FetchScroll.

public static final short
public static final short
public static final int
SQL_FETCH_DIRECTION

Information requested by GetInfo:

public static final short
SQL_FETCH_FIRST

Codes used for FetchOrientation in FetchScroll, and in DataSources.

public static final short
SQL_FETCH_FIRST_SYSTEM

Additional DataSources fetch directions.

public static final short
SQL_FETCH_FIRST_USER

Additional DataSources fetch directions.

public static final short
SQL_FETCH_LAST

Other codes used for FetchOrientation in FetchScroll.

public static final short
SQL_FETCH_NEXT

Codes used for FetchOrientation in FetchScroll, and in DataSources.

public static final short
SQL_FETCH_PRIOR

Other codes used for FetchOrientation in FetchScroll.

public static final short
SQL_FETCH_RELATIVE

Other codes used for FetchOrientation in FetchScroll.

public static final int
public static final int
public static final int
public static final int
public static final short
SQL_FILE_USAGE

Info types for GetInfo.

public static final short
SQL_FLOAT

SQL data type codes.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
SQL_GETDATA_EXTENSIONS

Information requested by GetInfo:

public static final short
SQL_GROUP_BY

Info types for GetInfo.

public static final short
SQL_GUID

SQL extended datatypes.

public static final short
SQL_HANDLE_DBC

Handle type identifiers.

public static final short
SQL_HANDLE_DESC

Handle type identifiers.

public static final short
SQL_HANDLE_ENV

Handle type identifiers.

public static final short
SQL_HANDLE_SENV

Handle type identifiers.

public static final short
SQL_HANDLE_STMT

Handle type identifiers.

public static final short
public static final short
public static final short
public static final short
public static final int
SQL_IDENTIFIER_CASE

Information requested by GetInfo:

public static final int
SQL_IDENTIFIER_QUOTE_CHAR

Information requested by GetInfo:

public static final short
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_INDEX_ALL

Reserved values for UNIQUE argument of Statistics.

public static final short
SQL_INDEX_CLUSTERED

Values that may appear in the result set of Statistics.

public static final short
SQL_INDEX_HASHED

Values that may appear in the result set of Statistics.

public static final short
SQL_INDEX_KEYWORDS

Info types for GetInfo.

public static final short
SQL_INDEX_OTHER

Values that may appear in the result set of Statistics.

public static final short
SQL_INDEX_UNIQUE

Reserved values for UNIQUE argument of Statistics.

public static final short
SQL_INFO_FIRST

Info types for GetInfo.

public static final short
public static final short
SQL_INITIALLY_DEFERRED

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_INITIALLY_IMMEDIATE

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_INSENSITIVE

Statement attribute values for cursor sensitivity.

public static final short
public static final short
SQL_INTEGER

SQL data type codes.

public static final int
SQL_INTEGRITY

Information requested by GetInfo:

public static final short
SQL_INTERVAL

SQL extended datatypes.

public static final short
SQL_INTERVAL_DAY

Interval code.

public static final short
public static final short
public static final short
public static final short
SQL_INTERVAL_HOUR

Interval code.

public static final short
public static final short
public static final short
SQL_INTERVAL_MINUTE

Interval code.

public static final short
public static final short
SQL_INTERVAL_MONTH

Interval code.

public static final short
SQL_INTERVAL_SECOND

Interval code.

public static final short
SQL_INTERVAL_YEAR

Interval code.

public static final short
public static final short
SQL_INVALID_HANDLE

Return values from functions.

public static final short
SQL_IS_DAY

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_DAY_TO_HOUR

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_DAY_TO_MINUTE

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_DAY_TO_SECOND

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_HOUR

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_HOUR_TO_MINUTE

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_HOUR_TO_SECOND

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final int
public static final int
public static final int
SQL_IS_INTEGER

Attribute types.

public static final short
SQL_IS_MINUTE

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_MINUTE_TO_SECOND

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_MONTH

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final int
SQL_IS_POINTER

Attribute types.

public static final short
SQL_IS_SECOND

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final int
public static final int
SQL_IS_SMALLINT

Attribute types.

public static final int
SQL_IS_UINTEGER

Attribute types.

public static final int
SQL_IS_USMALLINT

Attribute types.

public static final short
SQL_IS_YEAR

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final short
SQL_IS_YEAR_TO_MONTH

SQLINTERVAL enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
public static final short
SQL_KEYWORDS

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final int
SQL_LEN_BINARY_ATTR_OFFSET

Binary length for driver specific attributes.

public static final short
public static final short
public static final short
public static final short
SQL_LOCK_EXCLUSIVE

Lock options in SetPos.

public static final short
SQL_LOCK_NO_CHANGE

Lock options in SetPos.

public static final short
SQL_LOCK_TYPES

Info types for GetInfo.

public static final short
SQL_LOCK_UNLOCK

Lock options in SetPos.

public static final short
public static final short
SQL_LONGVARBINARY

SQL extended datatypes.

public static final short
SQL_LONGVARCHAR

SQL extended datatypes.

public static final short
public static final short
public static final int
SQL_MAX_CATALOG_NAME_LEN

Information requested by GetInfo:

public static final short
public static final int
SQL_MAX_COLUMN_NAME_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_COLUMNS_IN_GROUP_BY

Information requested by GetInfo:

public static final int
SQL_MAX_COLUMNS_IN_INDEX

Information requested by GetInfo:

public static final int
SQL_MAX_COLUMNS_IN_ORDER_BY

Information requested by GetInfo:

public static final int
SQL_MAX_COLUMNS_IN_SELECT

Information requested by GetInfo:

public static final int
SQL_MAX_COLUMNS_IN_TABLE

Information requested by GetInfo:

public static final int
SQL_MAX_CONCURRENT_ACTIVITIES

Information requested by GetInfo:

public static final int
SQL_MAX_CURSOR_NAME_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_DRIVER_CONNECTIONS

Information requested by GetInfo:

public static final short
SQL_MAX_DSN_LENGTH

Generally useful constants.

public static final int
SQL_MAX_IDENTIFIER_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_INDEX_SIZE

Information requested by GetInfo:

public static final short
public static final int
SQL_MAX_MESSAGE_LENGTH

Maximum message length.

public static final int
SQL_MAX_NUMERIC_LEN

Internal representation of numeric data type.

public static final short
SQL_MAX_OPTION_STRING_LENGTH

Generally useful constants.

public static final short
public static final short
public static final short
public static final int
SQL_MAX_ROW_SIZE

Information requested by GetInfo:

public static final short
public static final short
public static final int
SQL_MAX_SCHEMA_NAME_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_STATEMENT_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_TABLE_NAME_LEN

Information requested by GetInfo:

public static final int
SQL_MAX_TABLES_IN_SELECT

Information requested by GetInfo:

public static final int
SQL_MAX_USER_NAME_LEN

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_CATALOG_NAME_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_COLUMN_NAME_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_COLUMNS_IN_GROUP_BY

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_COLUMNS_IN_INDEX

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_COLUMNS_IN_ORDER_BY

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_COLUMNS_IN_SELECT

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_CONCURRENT_ACTIVITIES

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_CURSOR_NAME_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_DRIVER_CONNECTIONS

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_IDENTIFIER_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_INDEX_SIZE

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_ROW_SIZE

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_SCHEMA_NAME_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_STATEMENT_LENGTH

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_TABLES_IN_SELECT

Information requested by GetInfo:

public static final int
SQL_MAXIMUM_USER_NAME_LENGTH

Information requested by GetInfo:

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_NAMED

Values of DESC_UNNAMED field in descriptor.

public static final int
public static final short
public static final short
public static final int
public static final short
SQL_NEED_DATA

Return values from functions.

public static final short
public static final int
public static final int
public static final short
SQL_NO_ACTION

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
public static final short
SQL_NO_DATA

Return values from functions.

public static final short
SQL_NO_DATA_FOUND

Return values from functions.

public static final short
SQL_NO_NULLS

Values of DESC_NULLABLE field in descriptor.

public static final short
public static final short
SQL_NO_TOTAL

Special return values for GetData.

public static final short
public static final int
public static final short
public static final short
public static final short
public static final short
SQL_NOT_DEFERRABLE

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_NTS

Flag for null-terminated string.

public static final int
SQL_NULL_COLLATION

Information requested by GetInfo:

public static final short
SQL_NULL_DATA

Special length/indicator values.

public static final long
SQL_NULL_HANDLE

Null handles return by AllocHandle.

public static final long
SQL_NULL_HDBC

Null handles return by AllocHandle.

public static final long
SQL_NULL_HDESC

Null handles return by AllocHandle.

public static final long
SQL_NULL_HENV

Null handles return by AllocHandle.

public static final long
SQL_NULL_HSTMT

Null handles return by AllocHandle.

public static final short
SQL_NULLABLE

Values of DESC_NULLABLE field in descriptor.

public static final short
SQL_NULLABLE_UNKNOWN

Value returned by GetTypeInfo to denote that it is not known whether or not a data type supports null values.

public static final short
SQL_NUMERIC

SQL data type codes.

public static final short
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_ODBC_VER

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final int
public static final int
SQL_OJ_CAPABILITIES

Information requested by GetInfo:

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final String
public static final short
public static final short
public static final int
SQL_ORDER_BY_COLUMNS_IN_SELECT

Information requested by GetInfo:

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
SQL_OUTER_JOIN_CAPABILITIES

Information requested by GetInfo:

public static final short
SQL_OUTER_JOINS

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
SQL_OWNER_TERM

Info types for GetInfo.

public static final short
SQL_OWNER_USAGE

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
SQL_PARAM_DATA_AVAILABLE

Return values from functions.

public static final short
public static final short
public static final short
public static final short
SQL_PARAM_INPUT

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
SQL_PARAM_INPUT_OUTPUT

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
SQL_PARAM_INPUT_OUTPUT_STREAM

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
SQL_PARAM_OUTPUT

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
SQL_PARAM_OUTPUT_STREAM

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
public static final short
public static final short
public static final short
SQL_PARAM_TYPE_DEFAULT

Defines used by Driver Manager when mapping SetParam to BindParameter.

public static final short
SQL_PARAM_TYPE_UNKNOWN

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_PC_NON_PSEUDO

Values that may appear in the result set of SpecialColumns.

public static final short
SQL_PC_NOT_PSEUDO

Defines for SpecialColumns (returned in the result set).

public static final short
SQL_PC_PSEUDO

Values that may appear in the result set of SpecialColumns.

public static final short
SQL_PC_UNKNOWN

Values that may appear in the result set of SpecialColumns.

public static final int
public static final int
public static final short
SQL_POS_OPERATIONS

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final short
SQL_POSITION

Operations in SetPos.

public static final short
public static final short
SQL_PRED_BASIC

Values returned by GetTypeInfo to show WHERE clause supported.

public static final short
SQL_PRED_CHAR

Values returned by GetTypeInfo to show WHERE clause supported.

public static final short
SQL_PRED_NONE

Values returned by GetTypeInfo to show WHERE clause supported.

public static final short
public static final short
SQL_PROCEDURE_TERM

Info types for GetInfo.

public static final short
SQL_PROCEDURES

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final short
SQL_PT_FUNCTION

Defines for Procedures (returned in the result set).

public static final short
SQL_PT_PROCEDURE

Defines for Procedures (returned in the result set).

public static final short
SQL_PT_UNKNOWN

Defines for Procedures (returned in the result set).

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
SQL_QUALIFIER_TERM

Info types for GetInfo.

public static final short
public static final short
public static final short
SQL_QUICK

Defines for Statistics.

public static final short
public static final short
public static final short
public static final short
public static final short
SQL_REAL

SQL data type codes.

public static final short
SQL_REFRESH

Operations in SetPos.

public static final short
public static final short
public static final short
SQL_RESTRICT

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_RESULT_COL

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
SQL_RETURN_VALUE

Defines for BindParameter and ProcedureColumns (returned in the result set).

public static final short
public static final short
SQL_ROW_ADDED

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_DELETED

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_ERROR

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_IDENTIFIER

Reserved value for the IdentifierType argument of SpecialColumns.

public static final short
SQL_ROW_IGNORE

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_NOROW

ExtendedFetch rgfRowStatus element values.

public static final short
public static final short
SQL_ROW_PROCEED

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_SUCCESS

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_SUCCESS_WITH_INFO

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_UPDATED

ExtendedFetch rgfRowStatus element values.

public static final short
SQL_ROW_UPDATES

Info types for GetInfo.

public static final short
SQL_ROWVER

Column types and scopes in SpecialColumns.

public static final int
public static final short
public static final int
public static final int
public static final int
public static final short
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_SCHEMA_TERM

Info types for GetInfo.

public static final short
SQL_SCHEMA_USAGE

Info types for GetInfo.

public static final short
SQL_SCOPE_CURROW

Values that may appear in the result set of SpecialColumns.

public static final short
SQL_SCOPE_SESSION

Values that may appear in the result set of SpecialColumns.

public static final short
SQL_SCOPE_TRANSACTION

Values that may appear in the result set of SpecialColumns.

public static final int
SQL_SCROLL_CONCURRENCY

Information requested by GetInfo:

public static final short
SQL_SCROLL_OPTIONS

Info types for GetInfo.

public static final int
public static final int
public static final int
public static final int
public static final int
SQL_SEARCH_PATTERN_ESCAPE

Information requested by GetInfo:

public static final short
public static final short
SQL_SENSITIVE

Statement attribute values for cursor sensitivity.

public static final int
SQL_SERVER_NAME

Information requested by GetInfo:

public static final short
SQL_SET_DEFAULT

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_SET_NULL

Defines for ForeignKeys (UPDATE_RULE and DELETE_RULE).

public static final short
SQL_SETPARAM_VALUE_MAX

Defines used by Driver Manager when mapping SetParam to BindParameter.

public static final short
public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_SIGNED_OFFSET

Sign offsets.

public static final short
SQL_SMALLINT

SQL data type codes.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_SPEC_MAJOR

Generally useful constants.

public static final short
SQL_SPEC_MINOR

Generally useful constants.

public static final int
SQL_SPECIAL_CHARACTERS

Information requested by GetInfo:

public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
public static final short
SQL_SQL92_GRANT

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
SQL_SQL92_REVOKE

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
SQL_SQLSTATE_SIZE

Generally useful constants.

public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_STILL_EXECUTING

Return values from functions.

public static final short
public static final int
public static final int
public static final int
public static final int
public static final int
public static final short
SQL_SUBQUERIES

Info types for GetInfo.

public static final short
SQL_SUCCESS

Return values from functions.

public static final short
SQL_SUCCESS_WITH_INFO

Return values from functions.

public static final int
public static final int
public static final int
public static final int
public static final short
public static final short
SQL_TABLE_STAT

Defines for Statistics (returned in the result set).

public static final short
SQL_TABLE_TERM

Info types for GetInfo.

public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_TIME

SQL extended datatypes.

public static final short
SQL_TIME_LEN

Date/time length constants.

public static final short
public static final short
public static final short
public static final short
SQL_TIMESTAMP

SQL extended datatypes.

public static final short
SQL_TIMESTAMP_LEN

Date/time length constants.

public static final short
SQL_TINYINT

SQL extended datatypes.

public static final int
SQL_TRANSACTION_CAPABLE

Information requested by GetInfo:

public static final int
SQL_TRANSACTION_ISOLATION_OPTION

Information requested by GetInfo:

public static final int
public static final int
public static final int
public static final int
public static final short
SQL_TRUE

CLI option values.

public static final int
SQL_TXN_CAPABLE

Information requested by GetInfo:

public static final int
SQL_TXN_ISOLATION_OPTION

Information requested by GetInfo:

public static final short
SQL_TYPE_DATE

One-parameter shortcuts for date/time data types.

public static final short
SQL_TYPE_NULL

NULL type.

public static final short
SQL_TYPE_TIME

One-parameter shortcuts for date/time data types.

public static final short
SQL_TYPE_TIMESTAMP

One-parameter shortcuts for date/time data types.

public static final int
public static final int
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
public static final short
SQL_UNICODE

UNICODE definitions.

public static final short
SQL_UNICODE_CHAR

UNICODE definitions.

public static final short
SQL_UNICODE_LONGVARCHAR

UNICODE definitions.

public static final short
SQL_UNICODE_VARCHAR

UNICODE definitions.

public static final short
SQL_UNION

Info types for GetInfo.

public static final short
public static final short
SQL_UNKNOWN_TYPE

SQL data type codes.

public static final short
SQL_UNNAMED

Values of DESC_UNNAMED field in descriptor.

public static final short
public static final short
SQL_UNSIGNED_OFFSET

Sign offsets.

public static final short
SQL_UNSPECIFIED

Statement attribute values for cursor sensitivity.

public static final short
SQL_UPDATE

Operations in SetPos.

public static final short
public static final int
public static final int
public static final int
SQL_USER_NAME

Information requested by GetInfo:

public static final short
SQL_VARBINARY

SQL extended datatypes.

public static final short
SQL_VARCHAR

SQL data type codes.

public static final short
SQL_WCHAR

WCHAR definitions.

public static final short
SQL_WLONGVARCHAR

WCHAR definitions.

public static final short
SQL_WVARCHAR

WCHAR definitions.

public static final int
SQL_XOPEN_CLI_YEAR

Information requested by GetInfo:

Constructor Summary

AccessConstructor and Description
protected
SQL()

Method Summary

Modifier and TypeMethod and Description
public static SharedLibrary
getLibrary()

Returns the odbc SharedLibrary.

public static short
nSQLAllocHandle(short HandleType, long InputHandle, long OutputHandle)

Unsafe version of: AllocHandle

public static short
nSQLAllocHandleStd(short fHandleType, long hInput, long phOutput)

public static short
nSQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, long TargetValuePtr, long BufferLength, long StrLen_or_Ind)

Unsafe version of: BindCol

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

public static short
nSQLBrowseConnect(long ConnectionHandle, long InConnectionString, short
the length of *InConnectionString, in characters
StringLength1
,
long OutConnectionString, short
length of the *OutConnectionString buffer, in characters.
BufferLength
,
long StringLength2Ptr)

Unsafe version of: BrowseConnect

public static short
nSQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, long CharacterAttributePtr, short BufferLength, long StringLengthPtr, long NumericAttributePtr)

Unsafe version of: ColAttribute

public static short
nSQLColumnPrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName, long szColumnName, short cchColumnName)

public static short
nSQLColumns(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long ColumnName, short NameLength4)

public static short
nSQLCompleteAsync(short HandleType, long Handle, long AsyncRetCodePtr)

Unsafe version of: CompleteAsync

public static short
nSQLConnect(long ConnectionHandle, long ServerName, short
the length of *ServerName in characters
NameLength1
,
long UserName, short
the length of *UserName in characters
NameLength2
,
long Authentication, short
the length of *Authentication in characters
NameLength3
)

Unsafe version of: Connect

public static short
nSQLDataSources(long EnvironmentHandle, short Direction, long ServerName, short
length of the *ServerName buffer, in characters; this does not need to be longer than MAX_DSN_LENGTH plus the null-termination character.
BufferLength1
,
long NameLength1Ptr, long Description, short
length in characters of the *Description buffer.
BufferLength2
,
long NameLength2Ptr)

Unsafe version of: DataSources

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

public static short
nSQLDescribeParam(long StatementHandle, short ParameterNumber, long DataTypePtr, long ParameterSizePtr, long DecimalDigitsPtr, long NullablePtr)

Unsafe version of: DescribeParam

public static short
nSQLDriverConnect(long ConnectionHandle, long WindowHandle, long InConnectionString, short
the length of *InConnectionString, in characters
StringLength1
,
long OutConnectionString, short
length of the *OutConnectionString buffer, in characters.
BufferLength
,
long StringLength2Ptr, short DriverCompletion)

Unsafe version of: DriverConnect

public static short
nSQLDrivers(long EnvironmentHandle, short Direction, long DriverDescription, short BufferLength1, long DescriptionLengthPtr, long DriverAttributes, short BufferLength2, long AttributesLengthPtr)

Unsafe version of: Drivers

public static short
nSQLExecDirect(long StatementHandle, long StatementText, int
length of StatementText in characters
TextLength
)

Unsafe version of: ExecDirect

public static short
nSQLExtendedFetch(long hstmt, short fFetchType, long irow, long pcrow, long rgfRowStatus)

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)

public static short
nSQLGetConnectAttr(long ConnectionHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)

Unsafe version of: GetConnectAttr

public static short
nSQLGetCursorName(long StatementHandle, long CursorName, short BufferLength, long NameLengthPtr)

Unsafe version of: GetCursorName

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

public static short
nSQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength, long StringLengthPtr)

Unsafe version of: GetDescField

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

public static short
nSQLGetDiagField(short HandleType, long Handle, short RecNumber, short DiagIdentifier, long DiagInfoPtr, short
If DiagIdentifier is an ODBC-defined diagnostic and DiagInfoPtr points to a character string or a binary buffer, this argument should be the length of *DiagInfoPtr. If DiagIdentifier is an ODBC-defined field and *DiagInfoPtr is an integer, BufferLength is ignored. If the value in *DiagInfoPtr is a Unicode string (when calling SQLGetDiagFieldW), the BufferLength argument must be an even number.

If DiagIdentifier is a driver-defined field, the application indicates the nature of the field to the Driver Manager by setting the BufferLength argument. BufferLength can have the following values:

  • If is a pointer to a character string, BufferLength is the length of the string or NTS.
  • If DiagInfoPtr is a pointer to a binary buffer, the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in BufferLength. This places a negative value in BufferLength.
  • If DiagInfoPtr is a pointer to a value other than a character string or binary string, BufferLength should have the value IS_POINTER.
  • If *DiagInfoPtr contains a fixed-length data type, BufferLength is IS_INTEGER, IS_UINTEGER, IS_SMALLINT, or IS_USMALLINT, as appropriate.
BufferLength
,
long StringLengthPtr)

Unsafe version of: GetDiagField

public static short
nSQLGetDiagRec(short HandleType, long Handle, short RecNumber, long SQLState, long NativeErrorPtr, long MessageText, short BufferLength, long TextLengthPtr)

Unsafe version of: GetDiagRec

public static short
nSQLGetEnvAttr(long EnvironmentHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)

Unsafe version of: GetEnvAttr

public static short
nSQLGetFunctions(long ConnectionHandle, short FunctionId, long SupportedPtr)

Unsafe version of: GetFunctions

public static short
nSQLGetInfo(long ConnectionHandle, short InfoType, long InfoValuePtr, short BufferLength, long StringLengthPtr)

Unsafe version of: GetInfo

public static short
nSQLGetStmtAttr(long StatementHandle, int Attribute, long ValuePtr, int BufferLength, long StringLengthPtr)

Unsafe version of: GetStmtAttr

public static short
nSQLNativeSql(long ConnectionHandle, long InStatementText, int TextLength1, long OutStatementText, int BufferLength, long TextLength2Ptr)

Unsafe version of: NativeSql

public static short
nSQLNumParams(long StatementHandle, long ParameterCountPtr)

Unsafe version of: NumParams

public static short
nSQLNumResultCols(long StatementHandle, long ColumnCountPtr)

Unsafe version of: NumResultCols

public static short
nSQLParamData(long StatementHandle, long ValuePtrPtr)

Unsafe version of: ParamData

public static short
nSQLParamOptions(long hstmt, long crow, long pirow)

public static short
nSQLPrepare(long StatementHandle, long StatementText, int TextLength)

Unsafe version of: Prepare

public static short
nSQLPrimaryKeys(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)

public static short
nSQLProcedureColumns(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName, long szColumnName, short cchColumnName)

public static short
nSQLProcedures(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szProcName, short cchProcName)

public static short
nSQLPutData(long StatementHandle, long DataPtr, long StrLen_or_Ind)

Unsafe version of: PutData

public static short
nSQLRowCount(long StatementHandle, long RowCountPtr)

Unsafe version of: RowCount

public static short
nSQLSetConnectAttr(long ConnectionHandle, int Attribute, long Value, int
if Attribute is an ODBC-defined attribute and Value points 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 Attribute is an ODBC-defined attribute and Value is an integer, StringLength is ignored.

If Attribute is a driver-defined attribute, the application indicates the nature of the attribute to the Driver Manager by setting the StringLength argument. StringLength can have the following values:

  • If Value is a pointer to a character string, then StringLength is the length of the string or NTS.
  • If Value is a pointer to a binary buffer, then the application places the result of the SQL_LEN_BINARY_ATTR(length) macro in StringLength. This places a negative value in StringLength.
  • If Value is a pointer to a value other than a character string or a binary string, then StringLength should have the value IS_POINTER.
  • If ValuePtr contains a fixed-length value, then StringLength is either IS_INTEGER or IS_UINTEGER, as appropriate.
StringLength
)

Unsafe version of: SetConnectAttr

public static short
nSQLSetCursorName(long StatementHandle, long CursorName, short NameLength)

Unsafe version of: SetCursorName

public static short
nSQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, long ValuePtr, int BufferLength)

Unsafe version of: SetDescField

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

public static short
nSQLSetEnvAttr(long EnvironmentHandle, int Attribute, long Value, int
if Value points 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.
StringLength
)

Unsafe version of: SetEnvAttr

public static short
nSQLSetStmtAttr(long StatementHandle, int Attribute, long Value, int StringLength)

Unsafe version of: SetStmtAttr

public static short
nSQLSpecialColumns(long StatementHandle, short IdentifierType, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Scope, short Nullable)

public static short
nSQLStatistics(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, short Unique, short Reserved)

public static short
nSQLTablePrivileges(long hstmt, long szCatalogName, short cchCatalogName, long szSchemaName, short cchSchemaName, long szTableName, short cchTableName)

public static short
nSQLTables(long StatementHandle, long CatalogName, short NameLength1, long SchemaName, short NameLength2, long TableName, short NameLength3, long TableType, short NameLength4)

public static short

Returns:

SUCCESS, SUCCESS_WITH_INFO, INVALID_HANDLE, or ERROR.

When allocating a handle other than an environment handle, if SQLAllocHandle returns ERROR, it sets OutputHandle to NULL_HDBC, NULL_HSTMT, or NULL_HDESC, depending on the value of HandleType, 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 the InputHandle argument.

SQLAllocHandle
(short
the type of handle to be allocated. One of:
HANDLE_ENVHANDLE_DBCHANDLE_STMTHANDLE_DESCHANDLE_SENV
HandleType
,
long
the input handle in whose context the new handle is to be allocated. If HandleType is HANDLE_ENV, this is NULL_HANDLE. If HandleType is HANDLE_DBC, this must be an environment handle, and if it is HANDLE_STMT or HANDLE_DESC, it must be a connection handle.
InputHandle
,
PointerBuffer
pointer to a buffer in which to return the handle to the newly allocated data structure
OutputHandle
)

MSDN Reference

Allocates an environment, connection, statement, or descriptor handle.

public static short
SQLAllocHandleStd(short fHandleType, long hInput, PointerBuffer phOutput)

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, ByteBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, ShortBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, IntBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, LongBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, FloatBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindCol(long StatementHandle, short ColumnNumber, short TargetType, DoubleBuffer TargetValuePtr, PointerBuffer StrLen_or_Ind)

MSDN Reference

Binds application data buffers to columns in the result set.

public static short
SQLBindParameter(long StatementHandle, short ParameterNumber, short InputOutputType, short ValueType, short ParameterType, long ColumnSize, short DecimalDigits, ByteBuffer ParameterValuePtr, PointerBuffer StrLen_or_IndPtr)

MSDN Reference

Binds a buffer to a parameter marker in an SQL statement.

public static short
SQLBrowseConnect(long
the connection handle
ConnectionHandle
,
ByteBuffer
browse request connection string
InConnectionString
,
ByteBuffer
pointer to a character buffer in which to return the browse result connection string. If OutConnectionString is NULL, StringLength2Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by OutConnectionString.
OutConnectionString
,
ShortBuffer
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 to BufferLength, the completed connection string in *OutConnectionString is truncated to BufferLength minus the length of a null-termination character.
StringLength2Ptr
)

MSDN Reference

Supports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source.

public static short
SQLBrowseConnect(long
the connection handle
ConnectionHandle
,
CharSequence
browse request connection string
InConnectionString
,
ByteBuffer
pointer to a character buffer in which to return the browse result connection string. If OutConnectionString is NULL, StringLength2Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by OutConnectionString.
OutConnectionString
,
ShortBuffer
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 to BufferLength, the completed connection string in *OutConnectionString is truncated to BufferLength minus the length of a null-termination character.
StringLength2Ptr
)

MSDN Reference

Supports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source.

public static short
SQLBulkOperations(long StatementHandle, short Operation)

MSDN Reference

Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.

public static short
SQLCancel(long StatementHandle)

MSDN Reference

Cancels the processing on a statement.

public static short
SQLCancelHandle(short HandleType, long Handle)

MSDN Reference

Cancels the processing on a connection or statement.

public static short
SQLCloseCursor(long StatementHandle)

MSDN Reference

Closes a cursor that has been opened on a statement and discards pending results.

public static short
SQLColAttribute(long StatementHandle, short ColumnNumber, short FieldIdentifier, ByteBuffer CharacterAttributePtr, ShortBuffer StringLengthPtr, PointerBuffer NumericAttributePtr)

MSDN Reference

Returns descriptor information for a column in a result set.

public static short
SQLColumnPrivileges(long hstmt, ByteBuffer szCatalogName, ByteBuffer szSchemaName, ByteBuffer szTableName, ByteBuffer szColumnName)

public static short
SQLColumns(long StatementHandle, ByteBuffer CatalogName, ByteBuffer SchemaName, ByteBuffer TableName, ByteBuffer ColumnName)

public static short
SQLCompleteAsync(short
the type of the handle on which to complete asynchronous processing. One of:
HANDLE_DBCHANDLE_STMT
HandleType
,
long
the handle on which to complete asynchronous processing. If Handle is not a valid handle of the type specified by HandleType, SQLCompleteAsync returns INVALID_HANDLE.
Handle
,
ShortBuffer
pointer to a buffer that will contain the return code of the asynchronous API. If AsyncRetCodePtr is NULL, SQLCompleteAsync returns ERROR.
AsyncRetCodePtr
)

SQLCompleteAsync can be used to determine when an asynchronous function is complete using either notification- or polling-based processing.

public static short
SQLConnect(long
the connection handle
ConnectionHandle
,
ByteBuffer
the data source name. The data might be located on the same computer as the program, or on another computer somewhere on a network
ServerName
,
ByteBuffer
the user identifier
UserName
,
ByteBuffer
the authentication string (typically the password)
Authentication
)

MSDN Reference

Establishes connections to a driver and a data source.

public static short
SQLConnect(long
the connection handle
ConnectionHandle
,
CharSequence
the data source name. The data might be located on the same computer as the program, or on another computer somewhere on a network
ServerName
,
CharSequence
the user identifier
UserName
,
CharSequence
the authentication string (typically the password)
Authentication
)

MSDN Reference

Establishes connections to a driver and a data source.

public static short
SQLCopyDesc(long SourceDescHandle, long TargetDescHandle)

MSDN Reference

Copies descriptor information from one descriptor handle to another.

public static short
SQLDataSources(long
the environment handle
EnvironmentHandle
,
short
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), or FETCH_FIRST_SYSTEM (to fetch the first system DSN).

When Direction is set to FETCH_FIRST, subsequent calls to SQLDataSources with Direction set to FETCH_NEXT return both user and system DSNs. When Direction is set to FETCH_FIRST_USER, all subsequent calls to SQLDataSources with Direction set to FETCH_NEXT return only user DSNs. When Direction is set to FETCH_FIRST_SYSTEM, all subsequent calls to SQLDataSources with Direction set to FETCH_NEXT return only system DSNs.

Direction
,
ByteBuffer
pointer to a buffer in which to return the data source name

If ServerName is NULL, NameLength1Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by ServerName.

ServerName
,
ShortBuffer
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 to BufferLength1, the data source name in *ServerName is truncated to BufferLength1 minus the length of a null-termination character.
NameLength1Ptr
,
ByteBuffer
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 Description is NULL, NameLength2Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by Description.

Description
,
ShortBuffer
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 to BufferLength2, the driver description in *Description is truncated to BufferLength2 minus the length of a null-termination character.
NameLength2Ptr
)

MSDN Reference

Returns information about a data source.

public static short
SQLDescribeCol(long StatementHandle, short ColumnNumber, ByteBuffer ColumnName, ShortBuffer NameLengthPtr, ShortBuffer DataTypePtr, PointerBuffer ColumnSizePtr, ShortBuffer DecimalDigitsPtr, ShortBuffer NullablePtr)

MSDN Reference

Returns the result descriptor — column name,type, column size, decimal digits, and nullability — for one column in the result set.

public static short
SQLDescribeParam(long StatementHandle, short ParameterNumber, ShortBuffer DataTypePtr, PointerBuffer ParameterSizePtr, ShortBuffer DecimalDigitsPtr, ShortBuffer NullablePtr)

MSDN Reference

Returns the description of a parameter marker associated with a prepared SQL statement.

public static short
SQLDisconnect(long
the connection handle
ConnectionHandle
)

MSDN Reference

Closes the connection associated with a specific connection handle.

public static short
SQLDriverConnect(long
the connection handle
ConnectionHandle
,
long
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.
WindowHandle
,
ByteBuffer
a full connection string, a partial connection string, or an empty string.
InConnectionString
,
ByteBuffer
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. If OutConnectionString is NULL, StringLength2Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by OutConnectionString.
OutConnectionString
,
ShortBuffer
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 to BufferLength, the completed connection string in *OutConnectionString is truncated to BufferLength minus the length of a null-termination character.
StringLength2Ptr
,
short
a flag that indicates whether the Driver Manager or driver must prompt for more connection information. One of:
DRIVER_NOPROMPTDRIVER_COMPLETEDRIVER_PROMPTDRIVER_COMPLETE_REQUIRED
DriverCompletion
)

MSDN Reference

SQLDriverConnect is an alternative to Connect.

public static short
SQLDriverConnect(long
the connection handle
ConnectionHandle
,
long
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.
WindowHandle
,
CharSequence
a full connection string, a partial connection string, or an empty string.
InConnectionString
,
ByteBuffer
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. If OutConnectionString is NULL, StringLength2Ptr will still return the total number of characters (excluding the null-termination character for character data) available to return in the buffer pointed to by OutConnectionString.
OutConnectionString
,
ShortBuffer
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 to BufferLength, the completed connection string in *OutConnectionString is truncated to BufferLength minus the length of a null-termination character.
StringLength2Ptr
,
short
a flag that indicates whether the Driver Manager or driver must prompt for more connection information. One of:
DRIVER_NOPROMPTDRIVER_COMPLETEDRIVER_PROMPTDRIVER_COMPLETE_REQUIRED
DriverCompletion
)

MSDN Reference

SQLDriverConnect is an alternative to Connect.

public static short
SQLDrivers(long EnvironmentHandle, short Direction, ByteBuffer DriverDescription, ShortBuffer DescriptionLengthPtr, ByteBuffer DriverAttributes, ShortBuffer AttributesLengthPtr)

MSDN Reference

Lists driver descriptions and driver attribute keywords.

public static short
SQLEndTran(short HandleType, long Handle, short CompletionType)

MSDN Reference

Requests a commit or rollback operation for all active operations on all statements associated with a connection.

public static short
SQLExecDirect(long
statement handle
StatementHandle
,
ByteBuffer
SQL statement to be executed
StatementText
)

MSDN Reference

Executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement.

public static short
SQLExecDirect(long
statement handle
StatementHandle
,
CharSequence
SQL statement to be executed
StatementText
)

MSDN Reference

Executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement.

public static short
SQLExecute(long
statement handle
StatementHandle
)

MSDN Reference

Executes a prepared statement, using the current values of the parameter marker variables if any parameter markers exist in the statement.

public static short
SQLExtendedFetch(long hstmt, short fFetchType, long irow, PointerBuffer pcrow, ShortBuffer rgfRowStatus)

public static short
SQLFetch(long StatementHandle)

MSDN Reference

Fetches the next rowset of data from the result set and returns data for all bound columns.

public static short
SQLFetchScroll(long StatementHandle, short FetchOrientation, long FetchOffset)

MSDN Reference

Fetches the specified rowset of data from the result set and returns data for all bound columns.

public static short
SQLForeignKeys(long hstmt, ByteBuffer szPkCatalogName, ByteBuffer szPkSchemaName, ByteBuffer szPkTableName, ByteBuffer szFkCatalogName, ByteBuffer szFkSchemaName, ByteBuffer szFkTableName)

public static short
SQLFreeHandle(short HandleType, long Handle)

MSDN Reference

Frees resources associated with a specific environment, connection, statement, or descriptor handle.

public static short
SQLFreeStmt(long StatementHandle, short Option)

MSDN Reference

Stops 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.

public static short
public static short
SQLGetCursorName(long StatementHandle, ByteBuffer CursorName, ShortBuffer NameLengthPtr)

MSDN Reference

Returns the cursor name associated with a specified statement.

public static short
SQLGetData(long StatementHandle, short Col_or_Param_Num, short TargetType, ByteBuffer TargetValuePtr, PointerBuffer StrLen_or_IndPtr)

MSDN Reference

Retrieves data for a single column in the result set or for a single parameter after ParamData returns PARAM_DATA_AVAILABLE.

public static short
SQLGetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, ByteBuffer ValuePtr, IntBuffer StringLengthPtr)

MSDN Reference

Returns the current setting or value of a single field of a descriptor record.

public static short
SQLGetDescRec(long DescriptorHandle, short RecNumber, ByteBuffer Name, ShortBuffer StringLengthPtr, ShortBuffer TypePtr, ShortBuffer SubTypePtr, PointerBuffer LengthPtr, ShortBuffer PrecisionPtr, ShortBuffer ScalePtr, ShortBuffer NullablePtr)

MSDN Reference

Returns the current settings or values of multiple fields of a descriptor record.

public static short
SQLGetDiagField(short
a handle type identifier that describes the type of handle for which diagnostics are required. One of:
HANDLE_ENVHANDLE_DBCHANDLE_STMTHANDLE_DESCHANDLE_SENV
HandleType
,
long
a handle for the diagnostic data structure, of the type indicated by HandleType. If HandleType is HANDLE_ENV, Handle can be either a shared or an unshared environment handle.
Handle
,
short
indicates the status record from which the application seeks information. Status records are numbered from 1. If the DiagIdentifier argument indicates any field of the diagnostics header, RecNumber is ignored. If not, it should be more than 0.
RecNumber
,
short DiagIdentifier, ByteBuffer
pointer to a buffer in which to return the diagnostic information. The data type depends on the value of DiagIdentifier. If DiagInfoPtr is an integer type, applications should use a buffer of SQLULEN and 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 DiagInfoPtr is NULL, StringLengthPtr will still return the total number of bytes (excluding the null-termination character for character data) available to return in the buffer pointed to by DiagInfoPtr.

DiagInfoPtr
,
ShortBuffer
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 to BufferLength, the text in *DiagInfoPtr is truncated to BufferLength minus the length of a null-termination character.
StringLengthPtr
)

MSDN Reference

Returns 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.

public static short
SQLGetDiagRec(short HandleType, long Handle, short RecNumber, ByteBuffer SQLState, IntBuffer NativeErrorPtr, ByteBuffer MessageText, ShortBuffer TextLengthPtr)

MSDN Reference

Returns the current values of multiple fields of a diagnostic record that contains error, warning, and status information.

public static short
SQLGetEnvAttr(long EnvironmentHandle, int Attribute, ByteBuffer ValuePtr, IntBuffer StringLengthPtr)

MSDN Reference

Returns the current setting of a connection attribute.

public static short
SQLGetFunctions(long
the connection handle
ConnectionHandle
,
short FunctionId, ShortBuffer SupportedPtr)

MSDN Reference

Returns information about whether a driver supports a specific ODBC function.

public static short
SQLGetInfo(long
the connection handle
ConnectionHandle
,
short
type of information. One of:
MAX_DRIVER_CONNECTIONSMAXIMUM_DRIVER_CONNECTIONSMAX_CONCURRENT_ACTIVITIESMAXIMUM_CONCURRENT_ACTIVITIES
DATA_SOURCE_NAMEFETCH_DIRECTIONSERVER_NAMESEARCH_PATTERN_ESCAPE
DBMS_NAMEDBMS_VERACCESSIBLE_TABLESACCESSIBLE_PROCEDURES
CURSOR_COMMIT_BEHAVIORDATA_SOURCE_READ_ONLYDEFAULT_TXN_ISOLATIONIDENTIFIER_CASE
IDENTIFIER_QUOTE_CHARMAX_COLUMN_NAME_LENMAXIMUM_COLUMN_NAME_LENGTHMAX_CURSOR_NAME_LEN
MAXIMUM_CURSOR_NAME_LENGTHMAX_SCHEMA_NAME_LENMAXIMUM_SCHEMA_NAME_LENGTHMAX_CATALOG_NAME_LEN
MAXIMUM_CATALOG_NAME_LENGTHMAX_TABLE_NAME_LENSCROLL_CONCURRENCYTXN_CAPABLE
TRANSACTION_CAPABLEUSER_NAMETXN_ISOLATION_OPTIONTRANSACTION_ISOLATION_OPTION
INTEGRITYGETDATA_EXTENSIONSNULL_COLLATIONALTER_TABLE
ORDER_BY_COLUMNS_IN_SELECTSPECIAL_CHARACTERSMAX_COLUMNS_IN_GROUP_BYMAXIMUM_COLUMNS_IN_GROUP_BY
MAX_COLUMNS_IN_INDEXMAXIMUM_COLUMNS_IN_INDEXMAX_COLUMNS_IN_ORDER_BYMAXIMUM_COLUMNS_IN_ORDER_BY
MAX_COLUMNS_IN_SELECTMAXIMUM_COLUMNS_IN_SELECTMAX_COLUMNS_IN_TABLEMAX_INDEX_SIZE
MAXIMUM_INDEX_SIZEMAX_ROW_SIZEMAXIMUM_ROW_SIZEMAX_STATEMENT_LEN
MAXIMUM_STATEMENT_LENGTHMAX_TABLES_IN_SELECTMAXIMUM_TABLES_IN_SELECTMAX_USER_NAME_LEN
MAXIMUM_USER_NAME_LENGTHOJ_CAPABILITIESOUTER_JOIN_CAPABILITIESXOPEN_CLI_YEAR
CURSOR_SENSITIVITYDESCRIBE_PARAMETERCATALOG_NAMECOLLATION_SEQ
MAX_IDENTIFIER_LENMAXIMUM_IDENTIFIER_LENGTHINFO_FIRSTACTIVE_CONNECTIONS
ACTIVE_STATEMENTSDRIVER_HDBCDRIVER_HENVDRIVER_HSTMT
DRIVER_NAMEDRIVER_VERODBC_API_CONFORMANCEODBC_VER
ROW_UPDATESODBC_SAG_CLI_CONFORMANCEODBC_SQL_CONFORMANCEPROCEDURES
CONCAT_NULL_BEHAVIORCURSOR_ROLLBACK_BEHAVIOREXPRESSIONS_IN_ORDERBYMAX_OWNER_NAME_LEN
MAX_PROCEDURE_NAME_LENMAX_QUALIFIER_NAME_LENMULT_RESULT_SETSMULTIPLE_ACTIVE_TXN
OUTER_JOINSOWNER_TERMPROCEDURE_TERMQUALIFIER_NAME_SEPARATOR
QUALIFIER_TERMSCROLL_OPTIONSTABLE_TERMCONVERT_FUNCTIONS
NUMERIC_FUNCTIONSSTRING_FUNCTIONSSYSTEM_FUNCTIONSTIMEDATE_FUNCTIONS
CONVERT_BIGINTCONVERT_BINARYCONVERT_BITCONVERT_CHAR
CONVERT_DATECONVERT_DECIMALCONVERT_DOUBLECONVERT_FLOAT
CONVERT_INTEGERCONVERT_LONGVARCHARCONVERT_NUMERICCONVERT_REAL
CONVERT_SMALLINTCONVERT_TIMECONVERT_TIMESTAMPCONVERT_TINYINT
CONVERT_VARBINARYCONVERT_VARCHARCONVERT_LONGVARBINARYODBC_SQL_OPT_IEF
CORRELATION_NAMENON_NULLABLE_COLUMNSDRIVER_HLIBDRIVER_ODBC_VER
LOCK_TYPESPOS_OPERATIONSPOSITIONED_STATEMENTSBOOKMARK_PERSISTENCE
STATIC_SENSITIVITYFILE_USAGECOLUMN_ALIASGROUP_BY
KEYWORDSOWNER_USAGEQUALIFIER_USAGEQUOTED_IDENTIFIER_CASE
SUBQUERIESUNIONMAX_ROW_SIZE_INCLUDES_LONGMAX_CHAR_LITERAL_LEN
TIMEDATE_ADD_INTERVALSTIMEDATE_DIFF_INTERVALSNEED_LONG_DATA_LENMAX_BINARY_LITERAL_LEN
LIKE_ESCAPE_CLAUSEQUALIFIER_LOCATIONACTIVE_ENVIRONMENTSALTER_DOMAIN
SQL_CONFORMANCEDATETIME_LITERALSASYNC_MODEBATCH_ROW_COUNT
BATCH_SUPPORTCATALOG_LOCATIONCATALOG_NAME_SEPARATORCATALOG_TERM
CATALOG_USAGECONVERT_WCHARCONVERT_INTERVAL_DAY_TIMECONVERT_INTERVAL_YEAR_MONTH
CONVERT_WLONGVARCHARCONVERT_WVARCHARCREATE_ASSERTIONCREATE_CHARACTER_SET
CREATE_COLLATIONCREATE_DOMAINCREATE_SCHEMACREATE_TABLE
CREATE_TRANSLATIONCREATE_VIEWDRIVER_HDESCDROP_ASSERTION
DROP_CHARACTER_SETDROP_COLLATIONDROP_DOMAINDROP_SCHEMA
DROP_TABLEDROP_TRANSLATIONDROP_VIEWDYNAMIC_CURSOR_ATTRIBUTES1
DYNAMIC_CURSOR_ATTRIBUTES2FORWARD_ONLY_CURSOR_ATTRIBUTES1FORWARD_ONLY_CURSOR_ATTRIBUTES2INDEX_KEYWORDS
INFO_SCHEMA_VIEWSKEYSET_CURSOR_ATTRIBUTES1KEYSET_CURSOR_ATTRIBUTES2MAX_ASYNC_CONCURRENT_STATEMENTS
ODBC_INTERFACE_CONFORMANCEPARAM_ARRAY_ROW_COUNTSPARAM_ARRAY_SELECTSSCHEMA_TERM
SCHEMA_USAGESQL92_DATETIME_FUNCTIONSSQL92_FOREIGN_KEY_DELETE_RULESQL92_FOREIGN_KEY_UPDATE_RULE
SQL92_GRANTSQL92_NUMERIC_VALUE_FUNCTIONSSQL92_PREDICATESSQL92_RELATIONAL_JOIN_OPERATORS
SQL92_REVOKESQL92_ROW_VALUE_CONSTRUCTORSQL92_STRING_FUNCTIONSSQL92_VALUE_EXPRESSIONS
STANDARD_CLI_CONFORMANCESTATIC_CURSOR_ATTRIBUTES1STATIC_CURSOR_ATTRIBUTES2AGGREGATE_FUNCTIONS
DDL_INDEXDM_VERINSERT_STATEMENTCONVERT_GUID
UNION_STATEMENTASYNC_DBC_FUNCTIONSDRIVER_AWARE_POOLING_SUPPORTEDASYNC_NOTIFICATION
InfoType
,
ByteBuffer InfoValuePtr, ShortBuffer StringLengthPtr)

MSDN Reference

Returns general information about the driver and data source associated with a connection.

public static short
SQLGetInfo(long
the connection handle
ConnectionHandle
,
short
type of information. One of:
MAX_DRIVER_CONNECTIONSMAXIMUM_DRIVER_CONNECTIONSMAX_CONCURRENT_ACTIVITIESMAXIMUM_CONCURRENT_ACTIVITIES
DATA_SOURCE_NAMEFETCH_DIRECTIONSERVER_NAMESEARCH_PATTERN_ESCAPE
DBMS_NAMEDBMS_VERACCESSIBLE_TABLESACCESSIBLE_PROCEDURES
CURSOR_COMMIT_BEHAVIORDATA_SOURCE_READ_ONLYDEFAULT_TXN_ISOLATIONIDENTIFIER_CASE
IDENTIFIER_QUOTE_CHARMAX_COLUMN_NAME_LENMAXIMUM_COLUMN_NAME_LENGTHMAX_CURSOR_NAME_LEN
MAXIMUM_CURSOR_NAME_LENGTHMAX_SCHEMA_NAME_LENMAXIMUM_SCHEMA_NAME_LENGTHMAX_CATALOG_NAME_LEN
MAXIMUM_CATALOG_NAME_LENGTHMAX_TABLE_NAME_LENSCROLL_CONCURRENCYTXN_CAPABLE
TRANSACTION_CAPABLEUSER_NAMETXN_ISOLATION_OPTIONTRANSACTION_ISOLATION_OPTION
INTEGRITYGETDATA_EXTENSIONSNULL_COLLATIONALTER_TABLE
ORDER_BY_COLUMNS_IN_SELECTSPECIAL_CHARACTERSMAX_COLUMNS_IN_GROUP_BYMAXIMUM_COLUMNS_IN_GROUP_BY
MAX_COLUMNS_IN_INDEXMAXIMUM_COLUMNS_IN_INDEXMAX_COLUMNS_IN_ORDER_BYMAXIMUM_COLUMNS_IN_ORDER_BY
MAX_COLUMNS_IN_SELECTMAXIMUM_COLUMNS_IN_SELECTMAX_COLUMNS_IN_TABLEMAX_INDEX_SIZE
MAXIMUM_INDEX_SIZEMAX_ROW_SIZEMAXIMUM_ROW_SIZEMAX_STATEMENT_LEN
MAXIMUM_STATEMENT_LENGTHMAX_TABLES_IN_SELECTMAXIMUM_TABLES_IN_SELECTMAX_USER_NAME_LEN
MAXIMUM_USER_NAME_LENGTHOJ_CAPABILITIESOUTER_JOIN_CAPABILITIESXOPEN_CLI_YEAR
CURSOR_SENSITIVITYDESCRIBE_PARAMETERCATALOG_NAMECOLLATION_SEQ
MAX_IDENTIFIER_LENMAXIMUM_IDENTIFIER_LENGTHINFO_FIRSTACTIVE_CONNECTIONS
ACTIVE_STATEMENTSDRIVER_HDBCDRIVER_HENVDRIVER_HSTMT
DRIVER_NAMEDRIVER_VERODBC_API_CONFORMANCEODBC_VER
ROW_UPDATESODBC_SAG_CLI_CONFORMANCEODBC_SQL_CONFORMANCEPROCEDURES
CONCAT_NULL_BEHAVIORCURSOR_ROLLBACK_BEHAVIOREXPRESSIONS_IN_ORDERBYMAX_OWNER_NAME_LEN
MAX_PROCEDURE_NAME_LENMAX_QUALIFIER_NAME_LENMULT_RESULT_SETSMULTIPLE_ACTIVE_TXN
OUTER_JOINSOWNER_TERMPROCEDURE_TERMQUALIFIER_NAME_SEPARATOR
QUALIFIER_TERMSCROLL_OPTIONSTABLE_TERMCONVERT_FUNCTIONS
NUMERIC_FUNCTIONSSTRING_FUNCTIONSSYSTEM_FUNCTIONSTIMEDATE_FUNCTIONS
CONVERT_BIGINTCONVERT_BINARYCONVERT_BITCONVERT_CHAR
CONVERT_DATECONVERT_DECIMALCONVERT_DOUBLECONVERT_FLOAT
CONVERT_INTEGERCONVERT_LONGVARCHARCONVERT_NUMERICCONVERT_REAL
CONVERT_SMALLINTCONVERT_TIMECONVERT_TIMESTAMPCONVERT_TINYINT
CONVERT_VARBINARYCONVERT_VARCHARCONVERT_LONGVARBINARYODBC_SQL_OPT_IEF
CORRELATION_NAMENON_NULLABLE_COLUMNSDRIVER_HLIBDRIVER_ODBC_VER
LOCK_TYPESPOS_OPERATIONSPOSITIONED_STATEMENTSBOOKMARK_PERSISTENCE
STATIC_SENSITIVITYFILE_USAGECOLUMN_ALIASGROUP_BY
KEYWORDSOWNER_USAGEQUALIFIER_USAGEQUOTED_IDENTIFIER_CASE
SUBQUERIESUNIONMAX_ROW_SIZE_INCLUDES_LONGMAX_CHAR_LITERAL_LEN
TIMEDATE_ADD_INTERVALSTIMEDATE_DIFF_INTERVALSNEED_LONG_DATA_LENMAX_BINARY_LITERAL_LEN
LIKE_ESCAPE_CLAUSEQUALIFIER_LOCATIONACTIVE_ENVIRONMENTSALTER_DOMAIN
SQL_CONFORMANCEDATETIME_LITERALSASYNC_MODEBATCH_ROW_COUNT
BATCH_SUPPORTCATALOG_LOCATIONCATALOG_NAME_SEPARATORCATALOG_TERM
CATALOG_USAGECONVERT_WCHARCONVERT_INTERVAL_DAY_TIMECONVERT_INTERVAL_YEAR_MONTH
CONVERT_WLONGVARCHARCONVERT_WVARCHARCREATE_ASSERTIONCREATE_CHARACTER_SET
CREATE_COLLATIONCREATE_DOMAINCREATE_SCHEMACREATE_TABLE
CREATE_TRANSLATIONCREATE_VIEWDRIVER_HDESCDROP_ASSERTION
DROP_CHARACTER_SETDROP_COLLATIONDROP_DOMAINDROP_SCHEMA
DROP_TABLEDROP_TRANSLATIONDROP_VIEWDYNAMIC_CURSOR_ATTRIBUTES1
DYNAMIC_CURSOR_ATTRIBUTES2FORWARD_ONLY_CURSOR_ATTRIBUTES1FORWARD_ONLY_CURSOR_ATTRIBUTES2INDEX_KEYWORDS
INFO_SCHEMA_VIEWSKEYSET_CURSOR_ATTRIBUTES1KEYSET_CURSOR_ATTRIBUTES2MAX_ASYNC_CONCURRENT_STATEMENTS
ODBC_INTERFACE_CONFORMANCEPARAM_ARRAY_ROW_COUNTSPARAM_ARRAY_SELECTSSCHEMA_TERM
SCHEMA_USAGESQL92_DATETIME_FUNCTIONSSQL92_FOREIGN_KEY_DELETE_RULESQL92_FOREIGN_KEY_UPDATE_RULE
SQL92_GRANTSQL92_NUMERIC_VALUE_FUNCTIONSSQL92_PREDICATESSQL92_RELATIONAL_JOIN_OPERATORS
SQL92_REVOKESQL92_ROW_VALUE_CONSTRUCTORSQL92_STRING_FUNCTIONSSQL92_VALUE_EXPRESSIONS
STANDARD_CLI_CONFORMANCESTATIC_CURSOR_ATTRIBUTES1STATIC_CURSOR_ATTRIBUTES2AGGREGATE_FUNCTIONS
DDL_INDEXDM_VERINSERT_STATEMENTCONVERT_GUID
UNION_STATEMENTASYNC_DBC_FUNCTIONSDRIVER_AWARE_POOLING_SUPPORTEDASYNC_NOTIFICATION
InfoType
,
ShortBuffer InfoValuePtr, ShortBuffer StringLengthPtr)

MSDN Reference

Returns general information about the driver and data source associated with a connection.

public static short
SQLGetInfo(long
the connection handle
ConnectionHandle
,
short
type of information. One of:
MAX_DRIVER_CONNECTIONSMAXIMUM_DRIVER_CONNECTIONSMAX_CONCURRENT_ACTIVITIESMAXIMUM_CONCURRENT_ACTIVITIES
DATA_SOURCE_NAMEFETCH_DIRECTIONSERVER_NAMESEARCH_PATTERN_ESCAPE
DBMS_NAMEDBMS_VERACCESSIBLE_TABLESACCESSIBLE_PROCEDURES
CURSOR_COMMIT_BEHAVIORDATA_SOURCE_READ_ONLYDEFAULT_TXN_ISOLATIONIDENTIFIER_CASE
IDENTIFIER_QUOTE_CHARMAX_COLUMN_NAME_LENMAXIMUM_COLUMN_NAME_LENGTHMAX_CURSOR_NAME_LEN
MAXIMUM_CURSOR_NAME_LENGTHMAX_SCHEMA_NAME_LENMAXIMUM_SCHEMA_NAME_LENGTHMAX_CATALOG_NAME_LEN
MAXIMUM_CATALOG_NAME_LENGTHMAX_TABLE_NAME_LENSCROLL_CONCURRENCYTXN_CAPABLE
TRANSACTION_CAPABLEUSER_NAMETXN_ISOLATION_OPTIONTRANSACTION_ISOLATION_OPTION
INTEGRITYGETDATA_EXTENSIONSNULL_COLLATIONALTER_TABLE
ORDER_BY_COLUMNS_IN_SELECTSPECIAL_CHARACTERSMAX_COLUMNS_IN_GROUP_BYMAXIMUM_COLUMNS_IN_GROUP_BY
MAX_COLUMNS_IN_INDEXMAXIMUM_COLUMNS_IN_INDEXMAX_COLUMNS_IN_ORDER_BYMAXIMUM_COLUMNS_IN_ORDER_BY
MAX_COLUMNS_IN_SELECTMAXIMUM_COLUMNS_IN_SELECTMAX_COLUMNS_IN_TABLEMAX_INDEX_SIZE
MAXIMUM_INDEX_SIZEMAX_ROW_SIZEMAXIMUM_ROW_SIZEMAX_STATEMENT_LEN
MAXIMUM_STATEMENT_LENGTHMAX_TABLES_IN_SELECTMAXIMUM_TABLES_IN_SELECTMAX_USER_NAME_LEN
MAXIMUM_USER_NAME_LENGTHOJ_CAPABILITIESOUTER_JOIN_CAPABILITIESXOPEN_CLI_YEAR
CURSOR_SENSITIVITYDESCRIBE_PARAMETERCATALOG_NAMECOLLATION_SEQ
MAX_IDENTIFIER_LENMAXIMUM_IDENTIFIER_LENGTHINFO_FIRSTACTIVE_CONNECTIONS
ACTIVE_STATEMENTSDRIVER_HDBCDRIVER_HENVDRIVER_HSTMT
DRIVER_NAMEDRIVER_VERODBC_API_CONFORMANCEODBC_VER
ROW_UPDATESODBC_SAG_CLI_CONFORMANCEODBC_SQL_CONFORMANCEPROCEDURES
CONCAT_NULL_BEHAVIORCURSOR_ROLLBACK_BEHAVIOREXPRESSIONS_IN_ORDERBYMAX_OWNER_NAME_LEN
MAX_PROCEDURE_NAME_LENMAX_QUALIFIER_NAME_LENMULT_RESULT_SETSMULTIPLE_ACTIVE_TXN
OUTER_JOINSOWNER_TERMPROCEDURE_TERMQUALIFIER_NAME_SEPARATOR
QUALIFIER_TERMSCROLL_OPTIONSTABLE_TERMCONVERT_FUNCTIONS
NUMERIC_FUNCTIONSSTRING_FUNCTIONSSYSTEM_FUNCTIONSTIMEDATE_FUNCTIONS
CONVERT_BIGINTCONVERT_BINARYCONVERT_BITCONVERT_CHAR
CONVERT_DATECONVERT_DECIMALCONVERT_DOUBLECONVERT_FLOAT
CONVERT_INTEGERCONVERT_LONGVARCHARCONVERT_NUMERICCONVERT_REAL
CONVERT_SMALLINTCONVERT_TIMECONVERT_TIMESTAMPCONVERT_TINYINT
CONVERT_VARBINARYCONVERT_VARCHARCONVERT_LONGVARBINARYODBC_SQL_OPT_IEF
CORRELATION_NAMENON_NULLABLE_COLUMNSDRIVER_HLIBDRIVER_ODBC_VER
LOCK_TYPESPOS_OPERATIONSPOSITIONED_STATEMENTSBOOKMARK_PERSISTENCE
STATIC_SENSITIVITYFILE_USAGECOLUMN_ALIASGROUP_BY
KEYWORDSOWNER_USAGEQUALIFIER_USAGEQUOTED_IDENTIFIER_CASE
SUBQUERIESUNIONMAX_ROW_SIZE_INCLUDES_LONGMAX_CHAR_LITERAL_LEN
TIMEDATE_ADD_INTERVALSTIMEDATE_DIFF_INTERVALSNEED_LONG_DATA_LENMAX_BINARY_LITERAL_LEN
LIKE_ESCAPE_CLAUSEQUALIFIER_LOCATIONACTIVE_ENVIRONMENTSALTER_DOMAIN
SQL_CONFORMANCEDATETIME_LITERALSASYNC_MODEBATCH_ROW_COUNT
BATCH_SUPPORTCATALOG_LOCATIONCATALOG_NAME_SEPARATORCATALOG_TERM
CATALOG_USAGECONVERT_WCHARCONVERT_INTERVAL_DAY_TIMECONVERT_INTERVAL_YEAR_MONTH
CONVERT_WLONGVARCHARCONVERT_WVARCHARCREATE_ASSERTIONCREATE_CHARACTER_SET
CREATE_COLLATIONCREATE_DOMAINCREATE_SCHEMACREATE_TABLE
CREATE_TRANSLATIONCREATE_VIEWDRIVER_HDESCDROP_ASSERTION
DROP_CHARACTER_SETDROP_COLLATIONDROP_DOMAINDROP_SCHEMA
DROP_TABLEDROP_TRANSLATIONDROP_VIEWDYNAMIC_CURSOR_ATTRIBUTES1
DYNAMIC_CURSOR_ATTRIBUTES2FORWARD_ONLY_CURSOR_ATTRIBUTES1FORWARD_ONLY_CURSOR_ATTRIBUTES2INDEX_KEYWORDS
INFO_SCHEMA_VIEWSKEYSET_CURSOR_ATTRIBUTES1KEYSET_CURSOR_ATTRIBUTES2MAX_ASYNC_CONCURRENT_STATEMENTS
ODBC_INTERFACE_CONFORMANCEPARAM_ARRAY_ROW_COUNTSPARAM_ARRAY_SELECTSSCHEMA_TERM
SCHEMA_USAGESQL92_DATETIME_FUNCTIONSSQL92_FOREIGN_KEY_DELETE_RULESQL92_FOREIGN_KEY_UPDATE_RULE
SQL92_GRANTSQL92_NUMERIC_VALUE_FUNCTIONSSQL92_PREDICATESSQL92_RELATIONAL_JOIN_OPERATORS
SQL92_REVOKESQL92_ROW_VALUE_CONSTRUCTORSQL92_STRING_FUNCTIONSSQL92_VALUE_EXPRESSIONS
STANDARD_CLI_CONFORMANCESTATIC_CURSOR_ATTRIBUTES1STATIC_CURSOR_ATTRIBUTES2AGGREGATE_FUNCTIONS
DDL_INDEXDM_VERINSERT_STATEMENTCONVERT_GUID
UNION_STATEMENTASYNC_DBC_FUNCTIONSDRIVER_AWARE_POOLING_SUPPORTEDASYNC_NOTIFICATION
InfoType
,
IntBuffer InfoValuePtr, ShortBuffer StringLengthPtr)

MSDN Reference

Returns general information about the driver and data source associated with a connection.

public static short
SQLGetInfo(long
the connection handle
ConnectionHandle
,
short
type of information. One of:
MAX_DRIVER_CONNECTIONSMAXIMUM_DRIVER_CONNECTIONSMAX_CONCURRENT_ACTIVITIESMAXIMUM_CONCURRENT_ACTIVITIES
DATA_SOURCE_NAMEFETCH_DIRECTIONSERVER_NAMESEARCH_PATTERN_ESCAPE
DBMS_NAMEDBMS_VERACCESSIBLE_TABLESACCESSIBLE_PROCEDURES
CURSOR_COMMIT_BEHAVIORDATA_SOURCE_READ_ONLYDEFAULT_TXN_ISOLATIONIDENTIFIER_CASE
IDENTIFIER_QUOTE_CHARMAX_COLUMN_NAME_LENMAXIMUM_COLUMN_NAME_LENGTHMAX_CURSOR_NAME_LEN
MAXIMUM_CURSOR_NAME_LENGTHMAX_SCHEMA_NAME_LENMAXIMUM_SCHEMA_NAME_LENGTHMAX_CATALOG_NAME_LEN
MAXIMUM_CATALOG_NAME_LENGTHMAX_TABLE_NAME_LENSCROLL_CONCURRENCYTXN_CAPABLE
TRANSACTION_CAPABLEUSER_NAMETXN_ISOLATION_OPTIONTRANSACTION_ISOLATION_OPTION
INTEGRITYGETDATA_EXTENSIONSNULL_COLLATIONALTER_TABLE
ORDER_BY_COLUMNS_IN_SELECTSPECIAL_CHARACTERSMAX_COLUMNS_IN_GROUP_BYMAXIMUM_COLUMNS_IN_GROUP_BY
MAX_COLUMNS_IN_INDEXMAXIMUM_COLUMNS_IN_INDEXMAX_COLUMNS_IN_ORDER_BYMAXIMUM_COLUMNS_IN_ORDER_BY
MAX_COLUMNS_IN_SELECTMAXIMUM_COLUMNS_IN_SELECTMAX_COLUMNS_IN_TABLEMAX_INDEX_SIZE
MAXIMUM_INDEX_SIZEMAX_ROW_SIZEMAXIMUM_ROW_SIZEMAX_STATEMENT_LEN
MAXIMUM_STATEMENT_LENGTHMAX_TABLES_IN_SELECTMAXIMUM_TABLES_IN_SELECTMAX_USER_NAME_LEN
MAXIMUM_USER_NAME_LENGTHOJ_CAPABILITIESOUTER_JOIN_CAPABILITIESXOPEN_CLI_YEAR
CURSOR_SENSITIVITYDESCRIBE_PARAMETERCATALOG_NAMECOLLATION_SEQ
MAX_IDENTIFIER_LENMAXIMUM_IDENTIFIER_LENGTHINFO_FIRSTACTIVE_CONNECTIONS
ACTIVE_STATEMENTSDRIVER_HDBCDRIVER_HENVDRIVER_HSTMT
DRIVER_NAMEDRIVER_VERODBC_API_CONFORMANCEODBC_VER
ROW_UPDATESODBC_SAG_CLI_CONFORMANCEODBC_SQL_CONFORMANCEPROCEDURES
CONCAT_NULL_BEHAVIORCURSOR_ROLLBACK_BEHAVIOREXPRESSIONS_IN_ORDERBYMAX_OWNER_NAME_LEN
MAX_PROCEDURE_NAME_LENMAX_QUALIFIER_NAME_LENMULT_RESULT_SETSMULTIPLE_ACTIVE_TXN
OUTER_JOINSOWNER_TERMPROCEDURE_TERMQUALIFIER_NAME_SEPARATOR
QUALIFIER_TERMSCROLL_OPTIONSTABLE_TERMCONVERT_FUNCTIONS
NUMERIC_FUNCTIONSSTRING_FUNCTIONSSYSTEM_FUNCTIONSTIMEDATE_FUNCTIONS
CONVERT_BIGINTCONVERT_BINARYCONVERT_BITCONVERT_CHAR
CONVERT_DATECONVERT_DECIMALCONVERT_DOUBLECONVERT_FLOAT
CONVERT_INTEGERCONVERT_LONGVARCHARCONVERT_NUMERICCONVERT_REAL
CONVERT_SMALLINTCONVERT_TIMECONVERT_TIMESTAMPCONVERT_TINYINT
CONVERT_VARBINARYCONVERT_VARCHARCONVERT_LONGVARBINARYODBC_SQL_OPT_IEF
CORRELATION_NAMENON_NULLABLE_COLUMNSDRIVER_HLIBDRIVER_ODBC_VER
LOCK_TYPESPOS_OPERATIONSPOSITIONED_STATEMENTSBOOKMARK_PERSISTENCE
STATIC_SENSITIVITYFILE_USAGECOLUMN_ALIASGROUP_BY
KEYWORDSOWNER_USAGEQUALIFIER_USAGEQUOTED_IDENTIFIER_CASE
SUBQUERIESUNIONMAX_ROW_SIZE_INCLUDES_LONGMAX_CHAR_LITERAL_LEN
TIMEDATE_ADD_INTERVALSTIMEDATE_DIFF_INTERVALSNEED_LONG_DATA_LENMAX_BINARY_LITERAL_LEN
LIKE_ESCAPE_CLAUSEQUALIFIER_LOCATIONACTIVE_ENVIRONMENTSALTER_DOMAIN
SQL_CONFORMANCEDATETIME_LITERALSASYNC_MODEBATCH_ROW_COUNT
BATCH_SUPPORTCATALOG_LOCATIONCATALOG_NAME_SEPARATORCATALOG_TERM
CATALOG_USAGECONVERT_WCHARCONVERT_INTERVAL_DAY_TIMECONVERT_INTERVAL_YEAR_MONTH
CONVERT_WLONGVARCHARCONVERT_WVARCHARCREATE_ASSERTIONCREATE_CHARACTER_SET
CREATE_COLLATIONCREATE_DOMAINCREATE_SCHEMACREATE_TABLE
CREATE_TRANSLATIONCREATE_VIEWDRIVER_HDESCDROP_ASSERTION
DROP_CHARACTER_SETDROP_COLLATIONDROP_DOMAINDROP_SCHEMA
DROP_TABLEDROP_TRANSLATIONDROP_VIEWDYNAMIC_CURSOR_ATTRIBUTES1
DYNAMIC_CURSOR_ATTRIBUTES2FORWARD_ONLY_CURSOR_ATTRIBUTES1FORWARD_ONLY_CURSOR_ATTRIBUTES2INDEX_KEYWORDS
INFO_SCHEMA_VIEWSKEYSET_CURSOR_ATTRIBUTES1KEYSET_CURSOR_ATTRIBUTES2MAX_ASYNC_CONCURRENT_STATEMENTS
ODBC_INTERFACE_CONFORMANCEPARAM_ARRAY_ROW_COUNTSPARAM_ARRAY_SELECTSSCHEMA_TERM
SCHEMA_USAGESQL92_DATETIME_FUNCTIONSSQL92_FOREIGN_KEY_DELETE_RULESQL92_FOREIGN_KEY_UPDATE_RULE
SQL92_GRANTSQL92_NUMERIC_VALUE_FUNCTIONSSQL92_PREDICATESSQL92_RELATIONAL_JOIN_OPERATORS
SQL92_REVOKESQL92_ROW_VALUE_CONSTRUCTORSQL92_STRING_FUNCTIONSSQL92_VALUE_EXPRESSIONS
STANDARD_CLI_CONFORMANCESTATIC_CURSOR_ATTRIBUTES1STATIC_CURSOR_ATTRIBUTES2AGGREGATE_FUNCTIONS
DDL_INDEXDM_VERINSERT_STATEMENTCONVERT_GUID
UNION_STATEMENTASYNC_DBC_FUNCTIONSDRIVER_AWARE_POOLING_SUPPORTEDASYNC_NOTIFICATION
InfoType
,
PointerBuffer InfoValuePtr, ShortBuffer StringLengthPtr)

MSDN Reference

Returns general information about the driver and data source associated with a connection.

public static short
public static short
SQLGetTypeInfo(long
the statement handle for the result set
StatementHandle
,
short
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_TYPES specifies that information about all data types should be returned.
DataType
)

MSDN Reference

Returns information about data types supported by the data source.

public static short
SQLMoreResults(long StatementHandle)

MSDN Reference

Determines whether more results are available on a statement containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initializes processing for those results.

public static short
SQLNativeSql(long
the connection handle
ConnectionHandle
,
ByteBuffer InStatementText, ByteBuffer OutStatementText, IntBuffer TextLength2Ptr)

MSDN Reference

Returns the SQL string as modified by the driver.

public static short
SQLNativeSql(long
the connection handle
ConnectionHandle
,
CharSequence InStatementText, ByteBuffer OutStatementText, IntBuffer TextLength2Ptr)

MSDN Reference

Returns the SQL string as modified by the driver.

public static short
SQLNumParams(long StatementHandle, ShortBuffer ParameterCountPtr)

MSDN Reference

Returns the number of parameters in an SQL statement.

public static short
SQLNumResultCols(long StatementHandle, ShortBuffer ColumnCountPtr)

MSDN Reference

Returns the number of columns in a result set.

public static short
SQLParamData(long StatementHandle, PointerBuffer ValuePtrPtr)

MSDN Reference

SQLParamData is used together with PutData to supply parameter data at statement execution time, and with GetData to retrieve streamed output parameter data.

public static short
SQLParamOptions(long hstmt, long crow, PointerBuffer pirow)

public static short
SQLPrepare(long StatementHandle, ByteBuffer StatementText)

MSDN Reference

Prepares an SQL string for execution.

public static short
SQLPrepare(long StatementHandle, CharSequence StatementText)

MSDN Reference

Prepares an SQL string for execution.

public static short
SQLPrimaryKeys(long hstmt, ByteBuffer szCatalogName, ByteBuffer szSchemaName, ByteBuffer szTableName)

public static short
SQLProcedureColumns(long hstmt, ByteBuffer szCatalogName, ByteBuffer szSchemaName, ByteBuffer szProcName, ByteBuffer szColumnName)

public static short
SQLProcedures(long hstmt, ByteBuffer szCatalogName, ByteBuffer szSchemaName, ByteBuffer szProcName)

public static short
SQLPutData(long StatementHandle, ByteBuffer DataPtr)

MSDN Reference

Allows an application to send data for a parameter or column to the driver at statement execution time.

public static short
SQLRowCount(long StatementHandle, PointerBuffer RowCountPtr)

MSDN Reference

Returns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an ADD, UPDATE_BY_BOOKMARK, or DELETE_BY_BOOKMARK operation in BulkOperations; or an UPDATE or DELETE operation in SetPos.

public static short
SQLSetConnectAttr(long
the connection handle
ConnectionHandle
,
int Attribute, ByteBuffer
pointer to the value to be associated with Attribute. Depending on the value of Attribute, Value will be an unsigned integer value or will point to a null-terminated character string. Note that the integral type of the Attribute argument may not be fixed length.
Value
)

MSDN Reference

Sets attributes that govern aspects of connections.

public static short
SQLSetCursorName(long StatementHandle, ByteBuffer CursorName)

MSDN Reference

Associates a cursor name with an active statement.

public static short
SQLSetDescField(long DescriptorHandle, short RecNumber, short FieldIdentifier, ByteBuffer ValuePtr)

MSDN Reference

Sets the value of a single field of a descriptor record.

public static short
SQLSetDescRec(long DescriptorHandle, short RecNumber, short Type, short SubType, long Length, short Precision, short Scale, ByteBuffer DataPtr, PointerBuffer StringLengthPtr, PointerBuffer IndicatorPtr)

MSDN Reference

Sets multiple descriptor fields that affect the data type and buffer bound to a column or parameter data.

public static short
SQLSetEnvAttr(long
the environment handle
EnvironmentHandle
,
int Attribute, ByteBuffer
pointer to the value to be associated with Attribute. Depending on the value of Attribute, Value will be a 32-bit integer value or point to a null-terminated character string.
Value
)

MSDN Reference

Sets attributes that govern aspects of environments.

public static short
SQLSetPos(long StatementHandle, long RowNumber, short Operation, short LockType)

MSDN Reference

Sets 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.

public static short
public static short
SQLSpecialColumns(long StatementHandle, short IdentifierType, ByteBuffer CatalogName, ByteBuffer SchemaName, ByteBuffer TableName, short Scope, short Nullable)

public static short
SQLStatistics(long StatementHandle, ByteBuffer CatalogName, ByteBuffer SchemaName, ByteBuffer TableName, short Unique, short Reserved)

public static short
SQLTablePrivileges(long hstmt, ByteBuffer szCatalogName, ByteBuffer szSchemaName, ByteBuffer szTableName)

public static short
SQLTables(long StatementHandle, ByteBuffer CatalogName, ByteBuffer SchemaName, ByteBuffer TableName, ByteBuffer TableType)

public static short
SQLTransact(long EnvironmentHandle, long
the connection handle
ConnectionHandle
,
short CompletionType)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait