Case and If statement issue in the sql

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

chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ah... you can't. That's the only downfall to this method is the files cannot have parameters in them. I was able to "work around" this issue because I had a limited number of parameter values and so created a file for each parameter value with that coded into the file and the actual parameter used in the filename. Hope that makes sense.

Don't know if that will work for you or not however.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply