Level 1 API

Overview of the functions that are defined in the MaxDB ODBC driver for the level 1 API

Function

Remarks

SQLBindParameter

-

SQLColumns

-

SQLDriverConnect

Keyword for the name of the database computer: SERVERNODE
Keyword for the name of the database instance: SERVERDB

SQLGetConnectAttr

Remarks

SQLGetData

-

SQLGetFunctions

Remarks

SQLGetInfo

Remarks

SQLGetStmtAttr

-

SQLGetTypeInfo

You can determine the data types supported by the MaxDB database system using the function SQLGetTypeInfo.

The following data types are supported:
CHAR, VARCHAR, DECIMAL, FIXED, INTEGER, SMALLINT, FLOAT, REAL, DOUBLE PRECISION, DATE, TIME, TIMESTAMP, LONG, CHAR BYTE, VARCHAR BYTE, LONG BYTE, BOOLEAN

If the database is configured so that UNICODE characters can be processed, MaxDB also supports the following data types:
CHAR UNICODE, VARCHAR UNICODE, LONG UNICODE

SQLParamData

-

SQLPutData

-

SQLSetConnectAttr

See SQLGetConnectAttr

SQLSetParam

-

SQLSetStmtAttr

-

SQLSpecialColumns

-

SQLStatistics

-

SQLTables

The MaxDB ODBC driver supports the following table types (szTableType):
ALIAS, RESULT, SNAPSHOT, SYSTEM, SYSTEM TABLE, TABLE, UNLOADED, VIEW