Bind Variables in ORAOCI9 stage replacement in parallel jobs
Posted: Mon May 11, 2015 8:42 am
I am converting all server jobs to parallel jobs from DataStage 8.7 to 9.1 and in the ORAOCI9 stage the sql uses bind variables. When I view data in the server jobs everything displays properly. When I make the similar stage in the 9.1 parallel job, Oracle Connector, the bind variables don't work. Also in the server job the two ORAOCI9 stages go into a transformer and in my new parallel job they go into a lookup stage because its the only one that supports reference links.
So my question is how could I replace the bind variables for this job to return the correct data?
So my question is how could I replace the bind variables for this job to return the correct data?