Field Function

pkl · Post by **pkl** » Thu Oct 14, 2004 2:13 pm

Hi,

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

Thanx,
Preethi

dhiraj · Post by **dhiraj** » Thu Oct 14, 2004 2:22 pm

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

pkl · Post by **pkl** » Thu Oct 14, 2004 2:32 pm

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

chulett · Post by **chulett** » Thu Oct 14, 2004 2:36 pm

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

dhiraj · Post by **dhiraj** » Thu Oct 14, 2004 3:38 pm

oops. Craig is right. don't know how i made that mistake.

We use parameter for batch start date in almost every job !