beautypg.com

Where the trigcond macro is – HP Integrity NonStop J-Series User Manual

Page 86

background image

Triggers

HP AutoSYNC User’s Guide522580-018

6-6

TRIGGER examples

where the TRIGCOND macro is:

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

== Name: TRIGCOND

== Purpose: Sample conditional sqlcomp depending on file

== code and OS version

== Usage:

== SYNC $data.test.sqobj TO \paris.$datab.testb.sqobj,

== TRIGGER "RUN TRIGCOND #SYNCFILE";

==

==

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

?tacl macro

#frame

== Setup

==

#push file^code release sqlcomp_out tos^version

#SET TNSR Q [#push TNSR] == result from #TOSVERSION

#SET TNSE R [#push TNSE]

== configure SQL catalog

#set my^catalog MYCATLG [#push my^catalog]

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

#set SYNCFILE %1% [#push SYNCFILE]

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

== get file code and OS version

#set file^code [#fileinfo /code/ [syncfile]]

#setmany tos^version release, [#tosversion]

== perform conditional SQLCOMP

[#case [file^code]

|100| == compiles on TNS/R or TNS/E

sqlcomp /outv sqlcomp_out, in [syncfile]/ catalog [my^catalog]

#outputv sqlcomp_out == forces display for recording in logfile

|700| == compiles only on TNS/R

[#if tos^version '=' "[TNSR]" |then|

sqlcomp /outv sqlcomp_out, in [syncfile]/ catalog [my^catalog]

#outputv sqlcomp_out == forces display for recording in logfile

|else| #output [syncfile] not compiled - code 700 invalid on TNS/E

]

|800| == compiles only on TNS/E

[#if tos^version '=' "[TNSE]" |then|

sqlcomp /outv sqlcomp_out, in [syncfile]/ catalog [my^catalog]

#outputv sqlcomp_out == forces display for recording in logfile

|else| #output [syncfile] not compiled - code 800 invalid on TNS/R

]

|otherwise| #output Unknown file code

] {end case}

#unframe

This manual is related to the following products: