Search found 4 matches

by rstaedter
Mon Feb 23, 2015 9:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I accomplish sequential file bursting in a parallel job?
Replies: 8
Views: 6864

It's always a sad thing to reply to your own post, but ... I somehow miss the options or probably fail to know the exact place and/or method where/how to specify the output directory and a "base file name pattern" (both are job parameters) for each file; In the end, I got it. From Job Para...
by rstaedter
Mon Feb 23, 2015 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I accomplish sequential file bursting in a parallel job?
Replies: 8
Views: 6864

ShaneMuir - thanks so much for your suggestion. I followed it for several reasons: 1. It looks like I'm on AIX. Sorry for the confusion; I only have access to the Windows-based GUI tools.... 2. The original data columns are already concatenated into one single, long record in the SQL Query of the Or...
by rstaedter
Fri Feb 20, 2015 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I accomplish sequential file bursting in a parallel job?
Replies: 8
Views: 6864

First, thanks for your reply.
Your description sounds exactly like what I'd like to have; even the inserted period before the key value.
I am (meaning: the client is) running 8.7.0.2. How fast they are going to upgrade remains to be seen.

Thanks again!
by rstaedter
Fri Feb 20, 2015 6:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I accomplish sequential file bursting in a parallel job?
Replies: 8
Views: 6864

Can I accomplish sequential file bursting in a parallel job?

I have an input link to a Sequential File Stage. One of the several columns contains 4-digit-time information: 2-digit year and 2-digit month. I'll call this column YYMM_CHAR, and this is my burst key. Examples for values would be 0902, 0508, 1312, 1502 and so on. The output of the Sequential File S...