setting parameter value in befor job routine
Posted: Wed Sep 28, 2005 6:28 am
I could be using the wrong approach but here i go:
What i want:
I want to add version numbes to the seq files that my jobs create
eg: c:\data\result #version#.csv
My Approach:
1. create a job parameter called version
2. add a before job routing to set the version parameter to a new value (using the KeyMgtGetNextVAlue routine)
3. add the param value to the seq file name eg: c:\data\result #version#.csv
My Problem:
1. I can get the version number in the routine successfully
2. BUT when i use the DSSetParam(DSJ.ME, "version", newversionvalue) function, it returns a DSJE.BADHANDLE error
Any suggestion on approach or why the error would be much appreciated.
What i want:
I want to add version numbes to the seq files that my jobs create
eg: c:\data\result #version#.csv
My Approach:
1. create a job parameter called version
2. add a before job routing to set the version parameter to a new value (using the KeyMgtGetNextVAlue routine)
3. add the param value to the seq file name eg: c:\data\result #version#.csv
My Problem:
1. I can get the version number in the routine successfully
2. BUT when i use the DSSetParam(DSJ.ME, "version", newversionvalue) function, it returns a DSJE.BADHANDLE error
Any suggestion on approach or why the error would be much appreciated.