column value as file name in sequential file stage

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2010 4:06 pm

Not sure what you mean. Can you provide an example?

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2010 5:19 pm

It can't be done. The File property is established when the stage opens.

There is a hard-coded solution for a small, finite and "known a priori" number of values.

anbu · Post by **anbu** » Thu Feb 25, 2010 9:30 pm

Write the column value to a file and use move command in after job subroutine to rename the file

mv CLM.dat `cat column_value_file`"_CLM.dat"

ray.wurlod · Post by **ray.wurlod** » Thu Feb 25, 2010 10:17 pm

It's not a case of "the" file, as I understand the problem. It's any number of files, named xxxx_CLM.dat, with xxxx coming from the data.

chulett · Post by **chulett** » Fri Feb 26, 2010 8:30 am

Server job. Folder stage.

dsedi · Post by **dsedi** » Fri Feb 26, 2010 9:27 am

ray.wurlod wrote:It can't be done. The File property is established when the stage opens.

There is a hard-coded solution for a small, finite and "known a priori" number of values. ...

Thank you.
yes. We are having the hard-coded solution and want to confirm the other possibilities.

dsedi · Post by **dsedi** » Fri Feb 26, 2010 9:32 am

chulett wrote:Server job. Folder stage.

Thanks Craig.
Useful info. Will explore that.