This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to use a control table to load data to a DB2 table (Cannot use in-DB tools).
Here is what I want to do.
Eg: Worflow Name : CCE_MEASURE_VALUE_MORTALITY_INDEX.yxmd
Before running CCE_MEASURE_VALUE_MORTALITY_INDEX.yxmd to read records from the DB2 tables, I want to write a record to a control table.
Next, in my CCE_MEASURE_VALUE_MORTALITY_INDEX.yxmd workflow I have SQL statement in the input tool where I want to read
SELECT MSR.*,ENCNTR.ENCNTR_IDFROM APP_VIZIENT.V_EXPLR_MSR MSRINNER JOIN APP_REPORTING.CCE_REPORTING_CNTL CNTLON CNTL.MSR_NM = MSR.MSR_NMWHEREDATE(MSR.MSR_DT) >=CNTL.LAST_LOAD_TMSTP
After I extract these records and load the data to another DB2 table I want to update the record in the control table to look like this
I have created a macros to insert a record to the control table :
And another macro to update the record in the control table :
So here is the issue:
My workflow looks like this
The APP_REPORTING_CNTL_start.yxmc writes a record to the control table. See row 2 in the below screenshot
However, the SQL query does not seem to pick up this record. Hence, it does not return any records. I have also tried using the Crewmacro List Runner but it did not seem to work as well.
@Dhanushka_A can you post the workflow/macro package?