Create a sequential file stage file name at runtime

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Create a sequential file stage file name at runtime

Post 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]
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post 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.
Last edited by asorrell on Mon Dec 02, 2013 8:37 pm, edited 1 time in total.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
tbtcust
Premium Member
Premium Member
Posts: 230
Joined: Tue Mar 04, 2008 9:07 am

Post by tbtcust »

Thanks Andy.
Post Reply