Page 1 of 1

Create a sequential file stage file name at runtime

Posted: Mon Dec 02, 2013 7:17 pm
by tbtcust
Hello All. Apologies for this question. I know I have seen chatter on this topic in the past but cannot seem to locate a link.

I have a need to create a text file via a Sequential File stage. I need to pass the file name, which is unknown at runtime and created in a Transform stage. I'm using 8.5, PX, AIX.

Is this possible?

Thanks in advance for any help.

[Note - changed "Sequence stage" to "Sequential File Stage" assuming it was a mistake. Andy]

Posted: Mon Dec 02, 2013 8:27 pm
by asorrell
Sequential File names cannot be created "on the fly" from data elements in DataStage 8.5. They can only be created using parameters (which are set at run time).

It is supported in a limited way in 9.1 via use of a "Key" column and setting "Use Value in Filename" property to True.

Posted: Mon Dec 02, 2013 8:37 pm
by tbtcust
Thanks Andy.