Search found 42189 matches
- Sat Dec 01, 2007 6:43 pm
- Forum: General
- Topic: Error log Routines
- Replies: 2
- Views: 1189
I'm sure many do. However, you will need to explain in detail what exactly you mean by 'error log routines' - particularly your definition of 'error log' in this context. The routine part we got. Post your question once in one forum. I suggest you delete the other two posts before we end up with thr...
- Sat Dec 01, 2007 8:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KeyMgtGetNextValue
- Replies: 7
- Views: 2695
That would be because you only moved the jobs to the new server and not the hashed file these values live in, namely SDKSequences, which lives in each account a.k.a Project. So it created it new and started everything back at 1. You could move it now if it's not 'too late'. That or search the forum ...
- Sat Dec 01, 2007 8:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look up Query with OR condition getting error ORA 1008
- Replies: 7
- Views: 1895
so
Mark fields as Key fields to allow their use in the where clause. And while you can certainly use an 'OR' in the Key Expression, it needs to be an assignment statement not just an expression. So...
Not good: "A or B"
Good: If X = "A" or X = "B" Then "Y" else "Z"
Not good: "A or B"
Good: If X = "A" or X = "B" Then "Y" else "Z"
- Fri Nov 30, 2007 9:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: copy command
- Replies: 2
- Views: 996
- Fri Nov 30, 2007 9:49 pm
- Forum: General
- Topic: missing image in report
- Replies: 4
- Views: 1281
- Fri Nov 30, 2007 9:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Look up Query with OR condition getting error ORA 1008
- Replies: 7
- Views: 1895
Re: Look up Query with OR condition getting error ORA 1008
Then in transformer we are adding expression from input link which is mapped to curr2 field. link1.curr or link1.quote_curr While not the cause of your error, but an error none-the-less: do not put expressions in your Key unless all you truly want to populate it with is TRUE or FALSE, i.e. 1 or 0.
- Fri Nov 30, 2007 5:13 pm
- Forum: General
- Topic: missing image in report
- Replies: 4
- Views: 1281
- Fri Nov 30, 2007 5:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Load Audit tables in Shared Container
- Replies: 3
- Views: 1337
- Fri Nov 30, 2007 10:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: position and count
- Replies: 6
- Views: 1527
- Fri Nov 30, 2007 10:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: position and count
- Replies: 6
- Views: 1527
- Fri Nov 30, 2007 9:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: position and count
- Replies: 6
- Views: 1527
- Fri Nov 30, 2007 8:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query regarding merge stage
- Replies: 1
- Views: 1063
- Fri Nov 30, 2007 8:12 am
- Forum: General
- Topic: Regarding director
- Replies: 2
- Views: 917
- Fri Nov 30, 2007 8:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with update existing rows and insert new rows in SQL
- Replies: 2
- Views: 1101
Welcome. :D First bit of advice would be to avoid the 'combo' Update actions. Best Practice is to evaluate inserts versus updates and use separate links for each action. Secondly, it's not about the first action 'failing' per se. With an update, it should only execute the insert if the update does n...
- Fri Nov 30, 2007 7:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To spilt the year to Months
- Replies: 4
- Views: 1250
Of course you can 'generate rows', all that needs is multiple output links from a transformer. That or you simply source from a transformer with the appropriate constraint. Your requirement isn't exactly clearly stated. However, it seems like Kirtikumar might have it right. If I was doing this, I'd ...