I'm trying to use use a job parameter in the derivation field for a column i a DB stage. My formula looks like this:
Code: Select all
ADD_MONTHS(TO_DATE('#Periode#', 'YYYYMM') -1, 1)
Somehow it seems that datastage does not replace #Periode# with the correct value set for the parameter.
The same parameter is used in the selection criterias and works fine there.
The generated SQL works if I switch the stage to "user defined sql" and use the wxact same query.
Does datastage support the use of job parameters in the derivation field?
brg
Michael Sars Norum