Job Parameter in Transformer Stage

[nandha]

Hi:
I have a Environment Variable defined in Administrator - DS_IWH_SCHEMA and value assigned

I included that in the Job Properties - $DS_IWH_SCHEMA with $PROJDEF

I am able to use this in the Oracle EE stage to specify the schema for connectivity #$DS_IWH_SCHEMA#.

But when i place it in the transformer stage to populate a column of a table (requirement is to populate the schema name in a table) . It is allowing me to place as $DS_IWH_SCHEMA (not with #$DS_IWH_SCHEMA#) , but doesn't compile.

*******************************************************

##E TFCP 000001 16:46:05(005) <transform> Error when checking composite operator: Unexpected tokens: ; [line 13,character 7].
##E TFCP 000012 16:46:05(006) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 13, character 7].
##E TFCP 000001 16:46:05(007) <transform> Error when checking composite operator: Unexpected tokens: ; [line 88,character 17].
##E TFCP 000027 16:46:05(008) <transform> Error when checking composite operator: Expected an operand; [line 88, character 15].
##E TFCP 000038 16:46:05(009) <transform> Error when checking composite operator: Expected semi-colon; [line 88, character 17].
##E TFCP 000001 16:46:05(010) <transform> Error when checking composite operator: Unexpected tokens: ; [line 401,character 41].
##E TFCP 000027 16:46:05(011) <transform> Error when checking composite operator: Expected an operand; [line 401, character 39].
##E TFCP 000038 16:46:05(012) <transform> Error when checking composite operator: Expected semi-colon; [line 401, character 41].

********************************************************

Appreciate any help.

Regards,
Nandha

[nandha]

Got an answer from another post , with a search string GetEnvironment.


Thanks,
Nandha