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?
Bind Variables in ORAOCI9 stage replacement in parallel jobs
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 3
- Joined: Mon May 04, 2015 11:15 am
Re: Bind Variables in ORAOCI9 stage replacement in parallel
About DataType Binding for Oracle - http://www-304.ibm.com/support/knowledg ... oracc.html
It provide you the Oracle Environment Variables for the Oracle Connector to handle some internal binding.
e.g. VARCHAR2 to NVARCHAR using CC_ORA_BIND_FOR_NCHARS
You can try this link - http://www-304.ibm.com/support/knowledg ... arora.html
This information will work in 9.1 as I've see my customer get it work in 9.1.2.
It provide you the Oracle Environment Variables for the Oracle Connector to handle some internal binding.
e.g. VARCHAR2 to NVARCHAR using CC_ORA_BIND_FOR_NCHARS
You can try this link - http://www-304.ibm.com/support/knowledg ... arora.html
This information will work in 9.1 as I've see my customer get it work in 9.1.2.
Regards
Felix
Felix