Administration Guide › Accessing Collected Events with ODBC and JDBC › Creating ODBC and JDBC Queries for Use with CA Enterprise Log Manager › SQL Support Limitations

SQL Support Limitations

CA Enterprise Log Manager does not support stored procedure calls, data control language (DCL) commands, or data definition language (DDL) commands.

CA Enterprise Log Manager does not support the following data manipulation language (DML) operations and keywords:

• UNION
• JOIN
• Nested SELECT
• INSERT
• UPDATE
• DELETE
• Transaction control operators like COMMIT, ROLLBACK, and so forth