I want to calculate CRC value for dynamic columns, we are in a type of product development, so it is upto customer to choose the columns, he wants to track the changes. So i thought of maintaing something like parameter file, and define the columns there. And while running the job, i want to read the parameter file and get the column names.
I wrote a routine which will get the jobname and linkname as input and give the output like
Code: Select all
Type2.PRODUCT_ID : '|' : Type2.DESCR
This is like the same way, we will do the concatenation in the job before calculating the CRC, So i thought it would work. But it is treating the value as a string and not taking the corresponding value from the columns.
Suppose if my input is like
Code: Select all
PRODUCT_ID DESCR
TEST_PROD TEST_PRODUCT
TST1 TEST_PRODUCT1
I want my job to work like
Code: Select all
TEST_PROD|TEST_PRODUCT
TST1|TEST_PRODUCT1
Now, my job is calculating the CRC value for the string "Type2.PRODUCT_ID : '|' : Type2.DESCR", Is there any way to substitute them with the corresponding incoming values.
If i use job parameters also, it is considering it as a string only and not substituting the values.
Thanks
Anand