beautypg.com

HP Integrity NonStop J-Series User Manual

Page 88

background image

Triggers

HP AutoSYNC User’s Guide522580-018

6-8

Note on Triggers that invoke SQLCI

Instead, the user should use the following command:

where the TRIGTACL macro is as follows:

The TACL macro invoked by the TRIGGER must reside on the destination system and
must utilize an INLINE SQLCI. Multiple AutoSYNC built-in arguments (#SYNCFILE,
#SOURCEFILE, so on) may be passed to the macro but code must be added to
retrieve the values.

SYNC $data.test.sqacct TO \paris.$datab.testb.sqacctb,
TRIGGER "RUN TRIGTACL #SYNCFILE";

?tacl macro

#frame

========================================================

== setup

==

#push sqlci_out

#set #inlineecho 1 [#push #inlineecho]

#set #inlineprefix // [#push #inlineprefix]

========================================================

== pick up the tacl parameter(s) from the trigger command

==

#set SYNCFILE %1% [#push SYNCFILE]

========================================================

== sample sqlci command and forcing display for the logfile

==

sqlci /inline , outv sqlci_out/

// secure [SYNCFILE] PROGID;

// exit;

#outputv sqlci_out == forces display for recording in logfile

#unframe

This manual is related to the following products: