Search found 42189 matches

by chulett
Fri Dec 06, 2013 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing multiple groups of recs to a shared container
Replies: 8
Views: 3559

Describe the contents of the shared container - what stages are there and what functions are they performing? Off the top of my head, this just looks like a Transformer using stage variables to do 'group change detection', perhaps supported by a Sort stage adding a Key Change column. Each time the g...
by chulett
Fri Dec 06, 2013 9:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: based on Date comparison fetch exact value
Replies: 3
Views: 1451

First off, there's absolutely no need to send me your post in a Private Message... as you can see I found it just fine right here. Secondly: i am unable to show correct image of my job design. Go back and look at your first post. Everything lines up there because I used code tags to preserve the whi...
by chulett
Fri Dec 06, 2013 7:56 am
Forum: General
Topic: version migration from DS 7.5.2 to DS 8.5
Replies: 7
Views: 1156

Again... if this is something you'd like help with, we'd need details.
by chulett
Thu Dec 05, 2013 5:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Policy in DataSet
Replies: 4
Views: 1554

Why not go back to the source for clarity and ask your official support provider?
by chulett
Thu Dec 05, 2013 2:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Identifying Header,Trailer and Detail in CFF Stage
Replies: 5
Views: 3978

If Server jobs are at all an acceptable solution, from what I recall there are several 'EBCDIC' routines in the SDK including ones that would unpack those fields for you.
by chulett
Thu Dec 05, 2013 11:13 am
Forum: General
Topic: DataStage 8.1 jobs not running
Replies: 9
Views: 1919

Yes we use a ksh script to call the dsjob executable passing all necessary parameters. Well, that answers half the question. Does your invocation of dsjob use one of the 'wait' options and if so does the script check the return code and either log it or pass it back to AutoSys? Specifically wonderi...
by chulett
Thu Dec 05, 2013 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: based on Date comparison fetch exact value
Replies: 3
Views: 1451

Welcome aboard. First thing I have to ask is - how 'new to the product' are you? What have you tried? What issues are you having? Unfortunately, all it looks like right now is someone gave you an assignment / set of requirements and you came and posted them here. We're happy to help but you need to ...
by chulett
Thu Dec 05, 2013 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing ORCHESTRATE.COLUMN NAME as DB2 table name property
Replies: 3
Views: 2510

I actually don't know if you could get away with that. Give it a try, let us know!
by chulett
Thu Dec 05, 2013 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter from Hashed to ODBC stage
Replies: 6
Views: 3934

It won't take a fully qualified table name and thus only works with an owner table. Unless, perhaps, you leverage a synonym?
by chulett
Wed Dec 04, 2013 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output
Replies: 11
Views: 3152

... or that. :wink:
by chulett
Wed Dec 04, 2013 7:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output
Replies: 11
Views: 3152

Post your XPath Expressions.
by chulett
Wed Dec 04, 2013 7:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing ORCHESTRATE.COLUMN NAME as DB2 table name property
Replies: 3
Views: 2510

Not possible. Those target stage values are resolved when the job starts and there's no way to pass data from inside the current job to those settings. You'll have to do it in two steps - one job looks up the table name and passes to the insert / processing job as a job parameter, then you use that ...
by chulett
Wed Dec 04, 2013 10:25 am
Forum: General
Topic: version migration from DS 7.5.2 to DS 8.5
Replies: 7
Views: 1156

Har har.

:wink:
by chulett
Wed Dec 04, 2013 9:45 am
Forum: General
Topic: Warning: Cannot open "OMD.XML.DIR"
Replies: 1
Views: 862

Do an exact search for "OMD.XML.DIR", several other discussions on the issue exist here.
by chulett
Wed Dec 04, 2013 9:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Sort Stage vs Inline Link Sort
Replies: 5
Views: 2911

Not sure about the default... others will have to answer that. As to the risk, sure, there's always that kind of resource issue risk when doing lots of anything. :wink: