Search found 42189 matches

by chulett
Wed Mar 03, 2010 6:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with XML Input Stage
Replies: 4
Views: 4529

You only see 'activity' when a file has been completely processed, so things look pretty normal when you parse many small files but one large file can look like a whole lot of nothing until it is done and then - bang. Thar she blows! :wink:
by chulett
Wed Mar 03, 2010 6:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid timestamp value
Replies: 14
Views: 9082

How the heck did your timestamp end up with a date value of "2009-10-10-23" in it? :?
by chulett
Wed Mar 03, 2010 6:41 pm
Forum: General
Topic: How to Restart Datastage sequence when a job aborts?
Replies: 20
Views: 28100

If you set you job activity stages to reset and run instead of just run it should reset and run aborted jobs okay. Mmmmaybe. Really depends on why it aborted. I wasn't suggesting this be written off, just written intelligently. Have some kind of an out, a reasonableness test for 'stuckage' rather t...
by chulett
Wed Mar 03, 2010 6:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input and Primary Keys
Replies: 2
Views: 1218

Probably nothing. :wink: FYI - that 'key' field option marks the Repetition Element and is nothing like a Primary Key. Typically one would set it to the lowest level element but sometimes to have to play games. If you truly have many 'levels' then you may need to pull the levels out with one XML Inp...
by chulett
Wed Mar 03, 2010 6:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Sequences in Tranformer stage
Replies: 4
Views: 1390

Hmmm... shouldn't need a dummy or any kind of key at all, in fact. And that works in the derivation? Interesting as I've always fallen back on 'user-defined' sql without mentioning that column in the stage and then added something akin to that to whatever the stage generated.
by chulett
Wed Mar 03, 2010 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Sequences in Tranformer stage
Replies: 4
Views: 1390

OK... I deleted the private message I got asking for clarification on this so I don't recall exactly what you needed to know or were unsure about. If you still need some help, post back here with whatever questions you have and we'll see about getting you some answers.
by chulett
Wed Mar 03, 2010 12:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSTransformError, DSLogAbort
Replies: 3
Views: 1905

Right, I believe you'll need to write a small wrapper routine that (at the very least) simply calls the function with whatever you pass in as the argument. Then you can use it in the stage variable like that. For example: If DSLink89.retval <> 'NO DATA FOUND' then CallDSLogFatal("No Data, Acct ...
by chulett
Wed Mar 03, 2010 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open descriptor file to create: Permission denied
Replies: 3
Views: 9705

OK... let me be the first to ask the obvious question so we can get that out of the way. Does the user that your job is configured to run as have all of the requisite permissions to create / write to the 'StateLookup.ds' file in the location noted? Seems to me the answer is 'no' but only you can che...
by chulett
Wed Mar 03, 2010 12:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Elapsed time from dsjob..
Replies: 6
Views: 4926

I'll poke around but I think at the 'dsjob' level all you can do is diff the start and end times like you're already doing.
by chulett
Wed Mar 03, 2010 12:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connectivity error for datastage 8.1 client
Replies: 3
Views: 2464

For the record, the client is always on Windows. Is your server as well? And by 'different location' do you mean physically separated by a great distance? Or just two different local boxes? First question would be - did you search the forums for the 'failed to authenticate' message? It has been disc...
by chulett
Wed Mar 03, 2010 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get end of Month based on year and Month
Replies: 19
Views: 8627

Hmmm... just exactly how did they "make you" write the code for them? Did they find out where you live? :wink:
by chulett
Wed Mar 03, 2010 12:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSTransformError, DSLogAbort
Replies: 3
Views: 1905

Not sure what 'DSLogAbort' would be... did you mean DSLogFatal? What is "not working" about it? Details would be good.
by chulett
Wed Mar 03, 2010 12:08 pm
Forum: General
Topic: Evaluation of Datastage as an ETL tool
Replies: 4
Views: 5767

You should be asking all those questions of IBM Sales rather than people here. Have you done so or are you at least working with someone? :?