changing ODBCINI env variable value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dstest
Participant
Posts: 66
Joined: Sun Aug 19, 2007 10:52 pm

changing ODBCINI env variable value

Post by dstest »

Is there any way we can change the Projectwide (dsenv) defined ODCBINI value can be changed.

In dsenv i have the following entry for ODBCINI.

ODBCINI=/opt/dsadm/Ascential/DataStage/DSEngine/.odbc.ini

I want to change that value to ODBCINI=/home/dstest/.odbc.ini

I defined that value in my .profile and i ran the job.but still it is taking value from dsenv.Is there any way i can override this value

Thanks
dstest
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

All DataStage processes read dsenv to set up their environment. You can override by definining ODBCINI as a project environment variable and, possibly as well, bringing that environment variable into selected jobs as a job parameter. Use $ENV as the default value, and override as needed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply