Search found 42189 matches

by chulett
Mon Nov 16, 2009 7:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Triggers
Replies: 3
Views: 1380

If they literally only want the second job to run if the first job has failed, then yes. I assumed they wanted it to run 'even if' the first one failed.
by chulett
Mon Nov 16, 2009 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unhandled failure encountered executing command
Replies: 13
Views: 11653

And the problem I described in my previous post is the fact that you've asked no question. Rather you've just posted evidence of the same problem from your original post with another routine, something you've allegedly solved at this point and to which everything we've already discussed still applies.
by chulett
Mon Nov 16, 2009 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert Rows to columns
Replies: 2
Views: 1506

Specifically, search for vertical pivot or rows to columns should work as well.
by chulett
Mon Nov 16, 2009 7:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rt_log
Replies: 4
Views: 1408

Specifically, search for RTLogging and make sure you understand the consequences of changing its value.
by chulett
Mon Nov 16, 2009 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use different dsenv-Files depending on Userprofile???
Replies: 6
Views: 1953

Right idea, wrong execution. Never mentioned doing anything 'before job' but rather in your job. That means establishing them as Environment Variables in your project via the Administrator with values of $ENV so you don't immediately affect 100% of your existing jobs. Then add them as Job Parameters...
by chulett
Mon Nov 16, 2009 12:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unhandled failure encountered executing command
Replies: 13
Views: 11653

So... is this Resolved now? If so, please mark it as such using the button at the top of the page. If not, you'll need to ask a question.
by chulett
Sun Nov 15, 2009 6:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace SUB character in sequential file
Replies: 6
Views: 8384

The way you remove things from a file without outputting to a second is while reading it via the Filter option in the Sequential File stage, and whatever you can do from an Execute Command stage you can do there.
by chulett
Sun Nov 15, 2009 5:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To capture link count in a sequential file
Replies: 2
Views: 1575

Unclear... you need to read a file from a routine that has a link count written to it, or you've got the link count and now want to write it out? For the latter, you can echo it to a file or go through the whole OPENSEQ, WRITESEQ, CLOSESEQ shenanigans.
by chulett
Sun Nov 15, 2009 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Triggers
Replies: 3
Views: 1380

Unconditional.
by chulett
Sat Nov 14, 2009 10:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 3746

You're probably locking yourself. Does it run fine on one node?

ps. Your image link is no good.
by chulett
Sat Nov 14, 2009 7:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to delete some projects
Replies: 1
Views: 2474

If there is, that would need to come from your official support provider after they determine exactly how each project is corrupted. IMHO.
by chulett
Sat Nov 14, 2009 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage load problem
Replies: 10
Views: 3746

Depends on what the user needs to do. Chat with your DBA.
by chulett
Sat Nov 14, 2009 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL job filter data base on date supply by database
Replies: 6
Views: 2571

I don't see why not - providing this "filtering" can be done in the source query. To be honest, though, I didn't really grok the original question. :?