(Contents)(Next)

Core Level

SQLAllocConnect Windows, UNIX

No restrictions.

SQLAllocEnv Windows, UNIX

No restrictions.

SQLAllocStmt Windows, UNIX

No restrictions.

SQLBindCol Windows, UNIX

No restrictions.

Note:

If LONG columns are selected, the ODBC driver returns SQL_NO_TOTAL in pcbValue if cbValueMax is < the LONG column length. More parts of the LONG column can then be fetched with SQLGetData. In any other case, pcbValue shows the length of the copied bytes.

SQLCancel Windows, UNIX

No restrictions.

Note:

Usually, the ODBC driver works synchronously so that SQLCancel only closes the result set.

SQLColAttributes Windows, UNIX

No restrictions.

SQLConnect Windows, UNIX

No restrictions.

Note:

An application can have up to eight connections to the database server.

SQLDescribeCol Windows, UNIX

No restrictions.

SQLDisconnect Windows, UNIX

No restrictions.

SQLError Windows, UNIX

No restrictions.

Note:

SQLError stores one error for the corresponding handle. The application should call SQLError until the driver returns SQL_NO_DATA_FOUND.

SQLExecDirect Windows, UNIX

No restrictions.

Characteristics:

SQLExecDirect can be used to execute all DDL and DML statements. It can also be used to execute all ADABAS-specific statements (CREATE USER, MONITOR ON, ...).

SQLExecute Windows, UNIX

No restrictions.

Characteristics:

See SQLExecDirect.

A statement that cannot be processed with <prepare> is not executed until SQLExecute is being performed.

SQLFetch Windows, UNIX

No restrictions.

SQLFreeConnect Windows, UNIX

No restrictions.

SQLFreeEnv Windows, UNIX

No restrictions.

SQLFreeStmt Windows, UNIX

No restrictions.

SQLGetCursorName Windows, UNIX

No restrictions.

Note:

ADABAS cursor names are case-significant and can have up to 18 characters in length. This must be taken into account for SELECT FOR UPDATE because identifiers that are not enclosed in quotation marks (special identifiers) are automatically converted into uppercase characters. The ODBC driver uses the following schema to build default cursor names:

SQL_CURSOR_nnnn where nnnn corresponds to an internal count.

SQL_CUR_nnnnnnn with n >= 10000

SQLNumResultCols Windows, UNIX

No restrictions.

SQLPrepare Windows, UNIX

No restrictions.

Characteristics:

See SQLExecDirect.

SQLRowCount Windows, UNIX

No restrictions.

Note:

For all SELECT, INSERT, DELETE, etc. statements, SQLRowCount produces the number of rows involved. If the result set was not built, the ODBC driver returns -1 for the undeterminable number of rows concerned.

SQLSetCursorName Windows, UNIX

No restrictions.

SQLTransact Windows, UNIX

No restrictions.


(Contents)(Next)