Search found 42189 matches

by chulett
Tue May 20, 2008 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator Role Issues - Jobs not Found
Replies: 8
Views: 1336

Interesting. Found the same text you did, where it notes that basically that 'Edition' is just Director, Administrator and the Server components only. Never heard of such a beastie before, nor recall seeing it as an option when ordering the software. I wonder if that is still valid? Regardless, it d...
by chulett
Tue May 20, 2008 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI Date Conversion Failed
Replies: 5
Views: 2198

Then you shouldn't have any problems taking my advice. Your call, of course.
by chulett
Tue May 20, 2008 6:53 am
Forum: General
Topic: Removing missing or null warnings
Replies: 11
Views: 2900

No, that would be a perfectly fine solution. And sorry for the brain fart, forgot the null lookup would generate the same error. Too early here, not enough coffee. :wink:

ps. I'd document this in an annotation on the canvas.
by chulett
Tue May 20, 2008 6:48 am
Forum: General
Topic: OSH unavailable error
Replies: 3
Views: 1627

FYI - a good angst reliever, once you've discovered your mistake and copied the post into the correct forum, is to go back and delete the errant ones. You are allowed to do this with anything you post (topic starter or reply) as long as there are not replies to it.
by chulett
Tue May 20, 2008 6:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cpp script
Replies: 8
Views: 1400

Pretty much anything can be used 'after job'. Again, it would help if you explained what in the heck you mean by 'CPP script' in this context so people don't chase their tails.
by chulett
Tue May 20, 2008 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator Role Issues - Jobs not Found
Replies: 8
Views: 1336

Re: Operator Role Issues - Jobs not Found

I have a requirement where support people should only be allowed to view job logs and not be allowed to run it. I'm... not sure that's possible. You may need to look into a way to deliver the log contents to them, or start capturing the logs somewhere else they can access, like a database table per...
by chulett
Tue May 20, 2008 6:32 am
Forum: General
Topic: Rogue quotation mark appearing mid-file
Replies: 6
Views: 2059

Hmmm... that's near to impossible to say without eyes on the target. Or more details. What's different about this link from the other output that doesn't have the issue? What kind of transformations are you doing to this field, any? Do other records populate rfaind with a solitary 'N' without issue?...
by chulett
Tue May 20, 2008 6:27 am
Forum: General
Topic: Removing missing or null warnings
Replies: 11
Views: 2900

Well... that *is* the most likely cause, writing a null key to a hashed file. However, we can't really tell because you've just posted a snippet from the error. It would help greatly if you posted an example of the actual error so we can see it in its entirety. Also please clarify - you are only doi...
by chulett
Tue May 20, 2008 6:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cpp script
Replies: 8
Views: 1400

What exactly is a 'cpp script'? Uncompiled C++ code? :?
by chulett
Tue May 20, 2008 6:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert to AS400 hangs
Replies: 3
Views: 1383

That... smells like a bug. You may want to report it. :?
by chulett
Tue May 20, 2008 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning "main_program: Step has no operators"
Replies: 4
Views: 2476

Or use a Server job where you code under the 'Job Control' tab. You've got alot more legroom there for doing more than just the equivalent of ExecSH.
by chulett
Tue May 20, 2008 12:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer Stage
Replies: 11
Views: 5481

You have to customize the palette and add the BASIC Transformer, it is not there by default.
by chulett
Tue May 20, 2008 12:18 am
Forum: General
Topic: Sequential Files, Timestamps, Null values and Asterisks
Replies: 26
Views: 15059

Yes.
by chulett
Mon May 19, 2008 11:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the job warning limits in director log
Replies: 4
Views: 1651

Actually, the Designer ignores any default run time limit you may have established in the Director and always seems to default to 'unlimited'. The Director is the only thing that pays attention to that setting there. I for one have never seen it 'abort after 50' when you haven't set it to 50... unle...
by chulett
Mon May 19, 2008 11:19 pm
Forum: General
Topic: What is the difference between Stored Procedure and View?
Replies: 3
Views: 1190

Short answer? A view is a stored query. A stored procedure is stored code, a.k.a procedural language. Both are discrete database objects.