HP NonStop G-Series User Manual

Page 88

Advertising
background image

Triggers

HP AutoSYNC User’s Guide522580-019

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

Advertising
This manual is related to the following products: