Char(250) or Space as Parameter to my job

[samit_9999]

Hi ,

I want to create a parameter named Filler in my job and pass a value of Char(250) non printable character or Space .

Depending upon whether the filler parameter is a char(250) or a space i need to populate my output columns.

Example

If i have 4 columns in my output sequential file and 2 of these columns are to be populated with a filler , in which case depending upon the value that i have passed in filler parameter the columns should be populated.

Please help.

Sam

[chulett]

Str( #PARAM#,Size)

'Size' would be the number of times to repeat the value, the size of the resulting string.

[ray.wurlod]

Passing Char(250) as a parameter value should be perfectly legal. However to do so from the Job Run Options dialog (running job from Director or Designer) may well prove to be impossible. Create a job sequence - possibly containing just one Job activity - that will allow you to use an expression (and therefore the Char(250) function) when assigning a value to a job parameter.