APPX Software Library

Oracle, SQL Server and Other Databases

How to set the APPX_SQL_CMD to obtain a log of RDBMS activity.

To gather timing statistics using the Oracle, Sybase, or ODBC interfaces you must set the following environment variables prior to invoking Appx:

APPX_SQL_CMD=/... /rdbms.log (Unix users prefix with $ export)

For details on reading the log, see https://faq.appx.com/faq/cache/633.html

APPX_DBG_CODE=0x10000 (Unix users prefix with $ export)

For details on setting the variable to control the contents of the log,  see https://faq.appx.com/faq/cache/634.html