DSXchange

Posted: **Mon Apr 19, 2010 12:22 pm**

Hi,

Parameter set name :test
parameters in parameter set :schema

Used in SQL of RDBMS stage as

test.schema

When i check the data by "view data" it works fine and I can see the data as well.But when i execute the job an error is occurred as below.

Dynamic_RDBMS_0,0: Info:

Code: Select all

AP_TRANS_SAP_SAP_CALC_Feb13_WAY2.Dynamic_RDBMS_0: SELECT CoCd FROM #test.schema#.table

the parameter is not resolved into a value.

Appreciate your help.

Thanks,
Elias.

Posted: **Mon Apr 19, 2010 12:38 pm**

#test.schema# schema should start with $. So that could look like:
#test.$schema#

Thanks

Posted: **Mon Apr 19, 2010 12:48 pm**

If you define schema at User defined variable section in DataStage Admin, schema will become $schema.

Thanks

Posted: **Mon Apr 19, 2010 1:13 pm**

i haven't defined the variable at admin level.I have created a parameter set.
I understand if it was a environmental parameter we need a $ to access the parameter.But i was referring to a parameter in parameter set.

DSXchange

parameter set issue

parameter set issue