DSXchange

Help with a osh config issue pls...
We are using the DRS stage, to connect to a PostGres DB (via ODBC) in a Parallel job.

The User defined variables for the connect string, user, etc are being written out to the osh script as #DSCAPIOP__STG_DBNAME# (etc) and causing a connect failure.

We have tried setting the APT_DISABLE_COMBINATION to both true and false with no luck.

Can anyone give us a clue where else we might locate the configuration options which might help clear this up?

We are quite certain this is an osh config issue as we can view data in the DRS plug-in stage with no problem using either the #PROJDEF or entered values.


Thanks
John S.

Hi,
What exact error do you get?
Did you mark the stage to run sequentially?

IHTH,

Thanks for your reply we have somehow resolved this with the dsenv (but not sure how ha ha).

Hi John,

We are facing the same issue that you have mentioned. We have a Teradata API stage which works fine. But if it is pulled into a shared container the osh script generates DSCAPIOP_ before all the parameter names and causes a connect failure.

We are running Datastage 7.5.2 on Linux Suse.

Can you let us know what you did to the dsenv.

TIA
--Rich