Job Parameters

[myukassign]

I want to give the file name in the sequentuial file from job parameters.

E.g If i have job parameter like this.


Variable Value
===== =====
p_FoldName /dw/dsadm

p_File MyFile.Txt


I gave like this in the sequential file stage. #p_FoldName##p_File #

But not working.


CAn anyone tell me wht need to do?

If I give an extra slash at the end of the p_FoldName its working fine.

[ArndW]

When you use "#p_FoldName##p_File #" as your file name, what happen? Normally this will work correctly. (If that extra space at the last hash mark is cut-and-pasted then that is the cause of your problem).

[balajisr]

You need to give extra slash at the end of p_FoldName or #p_FoldName#/#p_File #

[ArndW]

Ahh, right. That too. But I still think the main problem is that space which is preventing the 2nd parameter to be used.

[ray.wurlod]

You're both right.
The slash is necessary to construct the pathname, and job parameter names can not include spaces.
So it's #p_FoldName#/#p_File# not #p_FoldName#/#p_File #

[chulett]

Or as noted in the original post, make sure the pathname parameter value has a trailing separator:

p_FoldName /dw/dsadm/
p_File MyFile.Txt

#p_FoldName##p_File#

Makes it more portable if that is a consideration. However, I put the slash between the parameters as there's no chance of going from UNIX to Windows here and peoples tend to forget to supply the trailing slash.

[myukassign]

Yup!

Thanks a for all suggestions.

I think I need to put an extra slash.

:D m happy

[chulett]

Then time to mark as Resolved with the big button at the top of the page.

[myukassign]

yep done