Re: Can i get current SQL statement in a trigger?

From: Robert Miller <rwmiller_at_gte.net>
Date: 1997/04/18
Message-ID: <5j8h40$ri8$5@news7.gte.net>#1/1

What Mainframe DB is it. A transparent gateway (SQL GATEWAY) makes the MF table look like a local table.

Also, their may be a SQL or transparent Gateway (DB2, DRDA) or Procedural Gateway (CICS, IMS/TM) that can greatly simplify this.

A trigger could fire a procedure that accesses the PG4APPC for instance. This in turn can start a CICS controlled COBOL program that runs against IMS or DBA SQL data for instance.

I recommend the Procedural Gateway over Transparent Gateways if transaction level is very high.

-- 


Robt



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

 Robert Miller          
 Oracle DBA  

 Client email:  rwmiller_at_gte.net
 Client phone:  (972) 751-6005

        Email: robt.miller_at_airmail.net
        Phone: (817) 458-5318
     Cellular: (214) 532-6558



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

Any opinions expressed are my own and may not
represent the view of any client.

Received on Fri Apr 18 1997 - 00:00:00 CDT