Group ODBC

Create a connection and connect to a data source

CREATE CONNECTION INTO <oSession> DATASOURCE <dsn> [DATABASE <db>] [USERID <user>] [PASSWORD <pwd>] [DIALOG [PARENT <parent>]] or CREATE CONNECTION INTO <oSession> CONNSTRING <cons> [DIALOG [PARENT <parent>]]

Deletes a connection

DELETE CONNECTION <oSession>

Displays the ODBC administrator dialog

OdbcAdmin([<oParent>]) --> lSuccess

Returns current state of ODBCDBE related settings

OdbcDebug([<aoSession>]) --> aOdbcInfo

Retrieves SQL keywords of the current data source.

OdbcListSqlKeywords([<oSession>]) --> aKeywords

Retrieves or sets the file name of the ODBC trace mode

OdbcTraceFile([<cFileName>]) --> cTraceFileName

Retrieves or sets the low-level trace mode of the ODBC driver manager.

OdbcTraceMode([<lTraceOn>]) --> lTraceMode

Write the OdbcDebug() results to a file

OdbcWriteDebug([<aoSession>], [<cFile>]) --> lSuccess

Executes an SQL statement

SQL <statement> [VIA <session>] or SQL <statement> INTO <variable> [VIA <session>] or SQL CMD <statement> [VIA <session>]