Administration Guide › Accessing Collected Events with ODBC and JDBC › Creating ODBC and JDBC Queries for Use with CA User Activity Reporting Module › SQL Support Limitations

SQL Support Limitations

CA User Activity Reporting Module does not support stored procedure calls, data control language (DCL) commands, or data definition language (DDL) commands.

CA User Activity Reporting Module 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