Hi,
We have a requirement to maintain an audit table as follows:
CREATE TABLE PRFWSTG.PRSAUDIT
(
TABLENAME CHARACTER(30)
, PRETABLECOUNT INTEGER
, FILECOUNT INTEGER
, POSTTABLECOUNT INTEGER
, PRS_TIMESTAMP TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
We are still in development on this and we are updating the various columns in our jobs but would like to as a final step we would like to dictate s processing decision based on the value of
if POSTTABLECOUNT = (PRETABLECOUNT + FILECOUNT) then continue
else email notification.
I thought this would be the easiest piece but am not sure where this can/should go.
Any thoughts or experience with this would be appreciated.
Thanks - - John
Comparing columns in the same table to dictate processing
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Re: Comparing columns in the same table to dictate processin
in one transformer you calculate sum of two columns and in second transfomer's constraints, you can make a decision of job processing.
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes. You need to get the two values into the job sequence - typically via a job that selects them and loads them into its user status area or writes them into a file. Having retrieved them, you would use a Nested Condition activity with a custom trigger expression to make the decision.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.