Search found 42189 matches

by chulett
Thu Apr 16, 2009 8:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing data from a routine
Replies: 6
Views: 1890

Jeez, popular subject all of a sudden. You've already posted in the thread most relevant to this, anything we could say on the subject is there. And pretty much any post that mentions BCI is "relevant" to your issue.
by chulett
Thu Apr 16, 2009 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in control file when using Oracle Load
Replies: 9
Views: 2543

Sainath.Srinivasan wrote:Remember seeing a similar post with issue in control file size thus resulting in truncation of control file.

That was when there were 400+ fields in the table.
I remember seeing something similar as well. In other words, possibly a bug that your official support provider could have a patch for.
by chulett
Thu Apr 16, 2009 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reconciliation Error
Replies: 2
Views: 813

One row in = one row out, 11 hashed lookups notwithstanding.
by chulett
Thu Apr 16, 2009 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 3088

Two can play that game. :wink:
by chulett
Thu Apr 16, 2009 8:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 3088

Not sure how anyone here can really help, seeing as we're not there and not able to examine both servers ourselves. However, you are, which is why that duty falls to you and yours. Something is different between the two, something other than simply the CPU. Sure, there are teeny differences between ...
by chulett
Thu Apr 16, 2009 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: time conversion
Replies: 2
Views: 967

Exactly... what were you planning on using for the time portion here? If not another field or source then you'll need to do what Ray has shown.
by chulett
Thu Apr 16, 2009 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inconsistent AfterStage Subroutine
Replies: 6
Views: 2157

Only point of contention is that Ray mentions there being no output link on the first transformer when combined into a single process and thus the problem that IPC 'fixes'. Problem is you said it worked fine as an after-stage routine when associated with the first transformer, it was the second one ...
by chulett
Thu Apr 16, 2009 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert into SQL Server failing same table FK constraint
Replies: 4
Views: 1370

Scott, as Mike noted that sql is only "similar" because the same tables are involved. The actual mechanisms are totally different. All that setting the Transaction Size to 0 means is to allow all records to be written to the database before the 'commit' is executed. Yes, that means you get...
by chulett
Thu Apr 16, 2009 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC connection to Foxpro
Replies: 9
Views: 3803

I don't know FoxPro but I sincerely doubt that is correct. Database is just typically the name itself and shouldn't contain any user/password info if that's what you are doing - that would come as part of the stage setup, the credentials needed to make that connection at runtime.
by chulett
Thu Apr 16, 2009 7:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update table directly from a routine
Replies: 3
Views: 2031

Different poster but a remarkably similar question.

viewtopic.php?p=323634
by chulett
Thu Apr 16, 2009 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data Stage Ver 7.5.2 with 4 Quad Core CPU
Replies: 9
Views: 3088

Not sure how anyone here can really help, seeing as we're not there and not able to examine both servers ourselves. However, you are, which is why that duty falls to you and yours. Something is different between the two, something other than simply the CPU. Sure, there are teeny differences between ...
by chulett
Wed Apr 15, 2009 5:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage 6.0 screen appears on citrix server
Replies: 1
Views: 1322

Not sure how anyone here could help, you need to thoroughly check your Citrix server and what is actually installed on it. Perhaps at one time it did have 6.0 installed. Maybe these 'few specific users' are going to the wrong machine? Who knows.
by chulett
Wed Apr 15, 2009 3:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Negative Number representation needs to be modified
Replies: 11
Views: 4567

Ah... the Masked Decimal conversions. They're not really all that well explained in the docs, you mostly have to infer how they work from the examples they include. What exactly does "MD2-" mean? A scale of two with a trailing minus sign?
by chulett
Wed Apr 15, 2009 8:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Negative Number representation needs to be modified
Replies: 11
Views: 4567

Sure, all kinds of ways to skin this cat. And I edited my post to remove the "End" statements from the code as they are not used in a derivation.