Attaching Parameter Set to DB Connection

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
basav_ds
Participant
Posts: 24
Joined: Sun Nov 11, 2007 11:19 pm
Location: Mumbai

Attaching Parameter Set to DB Connection

Post by basav_ds »

Hi,

I have created 3 environment variables to hold the values of ServerName, UserID and Password respectively. Then i define a
parameter set 'Param_Set_A' by adding these 3 environment variables. Now i want to attach 'Param_Set_A' to a DB2API Connection (call it 'DB2API_Conn_X'), but when i try to do that,in the option of Parameter set list to choose from,'Param_Set_A' is not present.

But if i create a parameter set using the option 'Create and Attach' in DB2API Connection, DB2API-stage-specific parameter set is created and displayed in list to choose from. But in this case, while creating Parameter set, 'Add Environment Variable' tab is disabled (Why?). So we can't add env variables in this parameter set.

Please can any one suggest me about how to use Environment variables in DB Connection(for setting Credentials i.e Server, UserID and Password)?
I never let school to interfere in my education
Post Reply