Does change in database configeration affect DRS/ODBC stage

prerana dixit · Post by **prerana dixit** » Tue Aug 25, 2009 2:59 am

If we want to upgrade/degarde database configeration to/from 9.2.0.7
does this change in database configeration affect DRS/ODBC stage in server jobs?

chulett · Post by **chulett** » Tue Aug 25, 2009 5:29 am

An Oracle version change? No, it really shouldn't. Will you be 'upgrading' the Oracle client on the DataStage server to match as well?

prerana dixit · Post by **prerana dixit** » Tue Aug 25, 2009 6:24 am

chulett wrote:An Oracle version change? No, it really shouldn't. Will you be 'upgrading' the Oracle client on the DataStage server to match as well?

Actually i want to either upgarde/degrade the oracle version on same release.
Eg:upgrade oracle version from 10.2.0.3 to 10.2.0.4 or
degrade oracle version from 9.2.0.9 to 9.2.0.7
So would this affect any of the DRS/ODBC stage in server jobs.

prerana dixit · Post by **prerana dixit** » Tue Aug 25, 2009 6:27 am

chulett wrote:An Oracle version change? No, it really shouldn't. Will you be 'upgrading' the Oracle client on the DataStage server to match as well?

To add to my previous reply :
Will this affect for upgrading from 9.2.0.5 to 9.2.0.7 and from 10.2.0.3 to 10.2.0.4 to be specific

chulett · Post by **chulett** » Tue Aug 25, 2009 7:46 am