Attaching Parameter Set to DB Connection
Posted: Thu Mar 20, 2008 4:17 am
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 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)?