parameter set issue

[elias.shaik]

Hi,

Parameter set name :test
parameters in parameter set :schema

Used in SQL of RDBMS stage as

Code: Select all

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.

[chowdhury99]

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

Thanks

[chowdhury99]

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

Thanks

[elias.shaik]

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.