Search found 42189 matches

by chulett
Fri Jul 13, 2007 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE FAILING
Replies: 12
Views: 3649

NO NEED TO SHOUT, I MAY BE OLD BUT NOT DEAF. YET. I find that hard to believe, but ok. So, you saying that '277' is not the next batch number and your Sequence job does not automatically handle failures? That property is not checked in the job? You see, when that option is turned on and a routine do...
by chulett
Fri Jul 13, 2007 11:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE FAILING
Replies: 12
Views: 3649

Is '277' your next batch number, by any chance? Do your Sequence jobs 'automatically handle activities that fail'?
by chulett
Fri Jul 13, 2007 10:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: attaching MORE THAN ONE link to jOB ACTIVITY
Replies: 5
Views: 1505

So... do you still have a problem? :?
by chulett
Fri Jul 13, 2007 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Collecting job statistics
Replies: 5
Views: 1290

DIY = Do It Yourself. :wink:
by chulett
Fri Jul 13, 2007 9:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to comapre 2 flat file
Replies: 2
Views: 1522

The Merge stage, since you actually mean 'join' rather than 'compare'.
by chulett
Fri Jul 13, 2007 9:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Hashfiles in a parallel job
Replies: 2
Views: 901

Re: Use of Hashfiles in a parallel job

Also, first of all, can hashfiles be used in parallel jobs in datastage or is it not advisable/available? First of all, can they be used? Technically yes, in a Server Shared Container. Should they be used? No. You've still got your Server Thinking Cap on. It needs to go back in the closet and you n...
by chulett
Fri Jul 13, 2007 9:47 am
Forum: General
Topic: Compare strings
Replies: 2
Views: 1109

Take DataStage out of the picture for now. How, regardless of tool, would you determine that those four 'incorrect' keys should really be mapped or equated to your one 'correct' key? Answer that question, quantify the business rule / requirements, and then worry about - "Ok, how do I do that in Data...
by chulett
Fri Jul 13, 2007 7:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Close statement in oracle enterprise edition stage
Replies: 5
Views: 1284

The Parallel Job Developer's Guide states: This is an optional property and only appears for the Load Write Method. Use it to specify any command, in single quotes, to be parsed and executed by the Oracle database on all processing nodes after the stage finishes processing the Oracle table. You can ...
by chulett
Fri Jul 13, 2007 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No closed loop scenario while updating the reference table
Replies: 5
Views: 1113

Only if you shed some light on the context where you found this 'closed loop scenario' phrase. :?
by chulett
Thu Jul 12, 2007 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp Comparision
Replies: 3
Views: 1687

fn21_load_ISS_ACT_REQ_tbl..Transformer_38: At row 1, link "DSLink57", while processing column "LAST_UPDT_TIMSTM" Value treated as NULL Attempt to convert String value "CCCCCC1" to Date type unsuccessful How can you expect it to store "CCCCCC1" in a DATE field? First step would be to determine where...
by chulett
Thu Jul 12, 2007 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage recovery in 24x7
Replies: 4
Views: 1587

But you can certainly make it failover, I've done this before for a Tru64 cluster. It won't be a transparent failover by any means, but other than that it can be done.
by chulett
Thu Jul 12, 2007 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to fined remove duplicate data?
Replies: 6
Views: 2026

[sigh]
by chulett
Thu Jul 12, 2007 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exposing jobs to webservice
Replies: 6
Views: 1511

Without even basic knowledge of web services, I don't see how you'll even get the SOA Edition installed and configured, let alone be able to use it. Do you currently have any kind of 'service oriented architecture' or capability in your company? People willing to pitch in and help with this? You eit...
by chulett
Thu Jul 12, 2007 7:16 am
Forum: General
Topic: dsjob
Replies: 7
Views: 2045

Check whether your user id has access and an entry to cron.alow file. It wouldn't already be in cron if that wasn't setup already, Kumar. So Danny... you need to tell us - is cron launching the script and the job isn't starting? Or is cron not even launching the script? If you've got a cron problem...
by chulett
Thu Jul 12, 2007 7:10 am
Forum: General
Topic: web version of datastage
Replies: 4
Views: 1210

Define what you mean by 'web version product' please.