Search found 42189 matches

by chulett
Sun Sep 25, 2011 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NUL Values
Replies: 7
Views: 3619

Forget anything like notepad, what does a UNIX hex editor show? Or a dump like "od -h" or whatever will give you a hex dump on your O/S.
by chulett
Sun Sep 25, 2011 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove null values appended to data
Replies: 15
Views: 6510

You need to determine the hex value of these characters. Be it "nulls" or otherwise, they will have a value and only by knowing what it is can you deal with it properly.
by chulett
Sun Sep 25, 2011 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job monitoring warning
Replies: 5
Views: 1947

Exactly. People should realize that - more than likely - they're not the first person on the planet to see their error and - more than likely - it's already been asked and answered here. Hence the search functionality. Only issue to be aware of here is that only the "exact" search really &...
by chulett
Sun Sep 25, 2011 8:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling SQL server stored procedure from datastage.
Replies: 23
Views: 19545

First off, stick to posting questions in your thread, there's no need to send private emails as well. :?

There is no name concern here. As noted, the parameter markers are positional here so the first ? is automagically matched to the value in the first column, the second to the second, etc.
by chulett
Sun Sep 25, 2011 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performace Issue
Replies: 5
Views: 1458

I don't know about Ray but I was hoping for a wee bit more detail than that.
by chulett
Sun Sep 25, 2011 8:54 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: WS Transformer error
Replies: 3
Views: 3907

Come on now... help us help you fix it. Give us some details as to what the heck your job is doing, stages used, etc.
by chulett
Sun Sep 25, 2011 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 (FP1) and TD 13.1
Replies: 4
Views: 5359

Re: DS 8.5 (FP1) and TD 13.1

Please advise ASAP, this is Urgent and Critical Case, and we may need to raise an urgent PMR if required. Client is really disappointed of this whole 8.5 version. Then it would seem the "urgent PMR" is in order and I would advise you to make sure the message in the last sentence is commun...
by chulett
Sun Sep 25, 2011 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load all Hashed file into memory
Replies: 26
Views: 9620

It looks like you've fallen into one of the classic traps we see here: when people come with a perceived solution to something in their mind and ask us how to implement that something rather than coming here with their actual problem and then asking if their solution is appropriate. You'd be amazed ...
by chulett
Sun Sep 25, 2011 8:06 am
Forum: General
Topic: Executing dsjob command from routine activity
Replies: 28
Views: 10541

Your understanding is incorrect. You can use ExecSH to run anything valid to be executed from the shell, hence the name. It really doesn't know or care if that is a script or a string of native operating system functions. Use the O/S functions if that's all you need, cobble together a script if you ...
by chulett
Sat Sep 24, 2011 11:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performace Issue
Replies: 5
Views: 1458

So 10 minutes or 10 hours? And what exactly are you doing in the shared container with those 11 transformers and 6 Oracle stages?
by chulett
Sat Sep 24, 2011 9:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job monitoring warning
Replies: 5
Views: 1947

Advise you search. Others have ask this same question before.

An exact search for "Failed to initialize job monitoring" returned 20 matches. Of course, one of those is yours. :wink:
by chulett
Sat Sep 24, 2011 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Peek stage and OCI stage
Replies: 7
Views: 2808

U mean to say, there is no benefit in using array size option? U didn't say any such thing, nor did Ray. Keep in mind the fact that "U" is one of our posters. As noted, it strictly controls how many rows are sent across the network 'in an array', nothing more and nothing less. There are t...
by chulett
Fri Sep 23, 2011 6:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to replace nulls with space in CFF stage
Replies: 8
Views: 2239

Why are you sending a space to a numeric field? There lies the root of your problem. :?
by chulett
Fri Sep 23, 2011 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling SQL server stored procedure from datastage.
Replies: 23
Views: 19545

AFAIK, it should be: EXECUTE PROC_NAME(?,?) And the question marks would match up to your first and second columns in the tab - assuming you are passing in parameter values from the link. If they are 'hard-coded' just put the values in the call and whatever columns you'd like in the stage as they wi...
by chulett
Fri Sep 23, 2011 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml performance
Replies: 13
Views: 3232

Franklin has his own thread now, let's not muck this one up with his stuff. :wink: