parameter

[adams06]

How can i pass a DATE at run time to a column.

I want to use a parameter

[chulett]

Just do it. Declare it as a parameter and enclose the parameter name in hash/pound signs in your derivation.

[adams06]

1. created a parameter in job parameter.
2. enclosed the parameter name in hash/pound

its not accepting

I double clicked the derivation->Browse->job Parameter (we get a list of job parameters)
i select the created parameter.

its with out a hash/pound sign

Why is not working with hash/pound sign

[chulett]

Where exactly you are trying to use it? Not all places need the hashes, column derivations don't. When in doubt, use the "..." Helper, it will always get it right.

[adams06]

sequential file

i am passing the parameter to the derivation of a sequential file.

[chulett]

Column derivation? As noted, hashes are not needed there, so it will work fine without them. Have you tried it yet? What happens?

[adams06]

Its working fine with out pound/Hash sign

Thanks, I learned a new point

[ray.wurlod]

Tip: always use the expression editor, so that you always get the correct syntax for operators and operands.