Search found 42189 matches

by chulett
Mon Jan 21, 2008 11:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in calling user defind PL/SQL
Replies: 36
Views: 5449

Curious how you are listed as a Premium Member and yet you state you aren't... how did that happen? :?
by chulett
Mon Jan 21, 2008 11:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ripple effects of increasing array size in oracle stage
Replies: 4
Views: 1337

Don't expect to accurately capture Oracle rejects with an array size of anything other than 1, it just doesn't work. The correct information gets logged but the information sent down your reject link will be for the wrong record.
by chulett
Mon Jan 21, 2008 11:45 pm
Forum: General
Topic: Job sequencer is not running in windows xp os
Replies: 1
Views: 700

You need to request that of your official support provider, have them make it available to you.
by chulett
Mon Jan 21, 2008 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_SCTEMP/jobname.fifo locked
Replies: 6
Views: 4613

Um... sorry, how to prevent what exactly?
by chulett
Mon Jan 21, 2008 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in calling user defind PL/SQL
Replies: 36
Views: 5449

Of course the stats package needs parameters, you've got four defined in the anonymous block. What I'm saying is that while you feel it may not "need" them because they are not dynamic, DataStage will feel the need for them to exist in some fashion. You'll need at least one Input and Output column t...
by chulett
Mon Jan 21, 2008 2:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in calling user defind PL/SQL
Replies: 36
Views: 5449

Input links but no output links means you should set the Procedure Type to Target it seems to me. That and I'm not sure that you can get away without defining any Input parameters, like column names for example. You may find that you'll need to pass in some of those data elements like owner and tabl...
by chulett
Mon Jan 21, 2008 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservice transformation stage and SOAP message
Replies: 3
Views: 923

No, because that still has SOAP-ENV elements in it. Pretty dang sure it just needs to be this: <SendSomething xmlns="http://www.abc.com/interface/"> <SenderID>STRING</SenderID> <ReceiverID>STRING</ReceiverID> <linenumber> <Line1>STRING<Line1/> </linenumber> </SendSomething >
by chulett
Mon Jan 21, 2008 12:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservice transformation stage and SOAP message
Replies: 3
Views: 923

The bits that are not part of the SOAP-ENV "Soap Envelope".
by chulett
Mon Jan 21, 2008 9:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Different Server Installations on Same Unix Box
Replies: 14
Views: 4244

While I would think there would be more to it than just 'the overhead of the two dsrpcd daemons instead of the one' your point is well taken. And the point re: maintenance is a big one. However, maybe you can think of it as a kind of RAID setup. Doubled your chances for a problem but when it does ha...
by chulett
Mon Jan 21, 2008 8:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get sequence name from DS_JOBS?
Replies: 3
Views: 1291

Code: Select all

LIST DICT DS_JOBS

And please try searching the forums, this has been a very popular topic lately and people get tired of explaining the same thing over and over. And over.
by chulett
Mon Jan 21, 2008 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using an array as a job handler
Replies: 30
Views: 11129

Umm... now. The 'down' message was from 3 years ago. :?
by chulett
Mon Jan 21, 2008 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Different Server Installations on Same Unix Box
Replies: 14
Views: 4244

Re: Two Different Server Installations on Same Unix Box

I am also in the same boat. My concern is, if the server prormance will descrese if i install the new ds version on the same AIX box. Please advise me. Of course. Install more anything that consumes resources and there will be less for everything else. You could always, to slightly misquote Roy Sch...
by chulett
Mon Jan 21, 2008 7:54 am
Forum: General
Topic: .DSX and XML
Replies: 4
Views: 1244

Here's a crazy idea - export something in both formats. Compare and contrast. Talk amongst yourselves!
by chulett
Mon Jan 21, 2008 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic Parameter File
Replies: 3
Views: 885

Use dsjob first to get a list of all parameters defined in the job. Pull any matching parameter names from your 'generic file' and only pass those to the job when you launch it. Or are we not talking about Job Parameters here? If not, please be more clear about the nature and usage of these 'variabl...
by chulett
Mon Jan 21, 2008 12:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob status
Replies: 5
Views: 1657

NO, not if it is still truly running. With phantoms still in place, then at least parts are still running. Does the job connect to a source or target database and are those connections still in place? If so, then a DBA can kill the session and the job should notice and abort. Otherwise, you'd need ...