Complex flat file with constraint

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
RK72
Participant
Posts: 154
Joined: Wed Sep 29, 2010 4:10 pm

Complex flat file with constraint

Post by RK72 »

We are reading an EBCDIC data file successfully with cff stage but there's one issue- not able to use constraint on the Output tab with a job parameter.

The requirement is to filter out certain records and if I hard-code the value it works fine but not when I use a job param. Funny thing is the drop down shows the param name itself so I'm not even typing it. It fails during Compilation saying

Code: Select all

Error compiling MFF output constraint: col1 = JobParam.date
Variable 'JobParam.pDate' not defined
Any one see this before?
nikhil_bhasin
Participant
Posts: 50
Joined: Tue Jan 19, 2010 4:14 am

Post by nikhil_bhasin »

well can you just double check the param names i can see 2 different params here
JobParam.date and JobParam.pDate
Post Reply