hi
my question is while using oracle database as source or target why we will use OCI stage why don't we use ODBC stage ?
datastage parallel job
Moderators: chulett, rschirm, roy
Please do a better job of choosing Subjects for your posts, it should be specific to your question or problem. At least you didn't just say "Hi" like we've seen in the past.
As to your question, why would you want to use ODBC over a native stage for any database? To me, ODBC is the 'stage of last resort', something you use when you have no other choice. For Oracle, that might be the situation when installing an Oracle client on your DataStage server is (for whatever reason) not possible.
As to your question, why would you want to use ODBC over a native stage for any database? To me, ODBC is the 'stage of last resort', something you use when you have no other choice. For Oracle, that might be the situation when installing an Oracle client on your DataStage server is (for whatever reason) not possible.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers