It is possible to create a Datacom SQL Trigger via a CA Datacom Server ODBJ or JDBC application?
Release: Any
Component: Datacom/DB
Datacom SQL
Datacom Server
ODBC
JDBC
Yes, it is possible to create an SQL Trigger via:
1. Java application that uses the CA Datacom Server JDBC driver client.
2. ODBC application that uses the CA Datacom Server ODBC driver client.
Currently, CA Datacom Core - 15.0 documentation SQL section "CREATE TRIGGER or CREATE RULE Statement" ( https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/reference/sql-reference/sql-statements/create-trigger-or-create-rule-statement.html ) is to be updated since as of this writing, it currently only mentions:
SQL CREATE TRIGGER statement can only be done in the following ways:
- Through the CA Datacom® Datadictionary™ Interactive SQL Service Facility (interactive)
- In an application program prepared using a CA Datacom®/DB SQL Preprocessor (embedded)
- By using CA Dataquery™ for CA Datacom® (SQL & Batch Modes)