CA Datacom Server application create SQL TRIGGER

Products

• Datacom

Issue/Introduction

It is possible to create a Datacom SQL Trigger via a CA Datacom Server ODBJ or JDBC application?

Environment

Release: Any

Component:  Datacom/DB

                        Datacom SQL

                        Datacom Server

ODBC

JDBC

Resolution

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.

Additional Information

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)