DSXchange

Hi,

Can I use a job parameter in the Field function as the string?

Thanx,
Preethi

If you are using the field function in a transformer, then you can.
Remember you should enclose the parameter name within # symbol.

eg Field(#DSN#,'|',1)
Where DSN is the parameter name.


Dhiraj

Hi Dhiraj,

I tried that , then it gave me an error saying expecting an exrpession. When I enclosed it , it returned a null string.

Thanx
Preethi

Derivations are one of the places where Job Parameters should not be wrapped in pound signs. Try just using DSN in the function.

oops. Craig is right. don't know how i made that mistake. We use parameter for batch start date in almost every job !