Search found 4 matches

by SilviusBrabo1
Wed Aug 17, 2011 1:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure: Wrong number or types of arguments (ORA)
Replies: 5
Views: 7476

FYI, in the last attempts, I did NOT foresee a parameter in the procedure stage and had the procedure statements generated automatically so here's what appears shaded:

BEGIN <procedure name>(:1); END;
by SilviusBrabo1
Wed Aug 17, 2011 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure: Wrong number or types of arguments (ORA)
Replies: 5
Views: 7476

Hi Chulett Thanks for your reply! 1. I've checked and the procedure type was currently set to "transform"; I've reset this to "Target" but that did not solve the issue for the first scenario. More specifically, I'm still receiving following errors when I define the reject output ...
by SilviusBrabo1
Tue Aug 16, 2011 5:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stored Procedure: Wrong number or types of arguments (ORA)
Replies: 5
Views: 7476

Stored Procedure: Wrong number or types of arguments (ORA)

Hi, I wanted to create a stored procedure (within a parallel job) to write the reject output to a dedicated Oracle table by means of an Oracle stored procedure. Although the invoked procedure will eventually contain several parameters (the rerect outpuy being one of them), it has been stripped to a ...
by SilviusBrabo1
Wed Jul 27, 2011 4:06 am
Forum: General
Topic: DSJOB: components required?
Replies: 1
Views: 928

DSJOB: components required?

Hi, I would need the dsjob utility on a Windows machine to remotely start jobs on a datastage server (UNIX). Since I exclusively need this utility on the machine concerned (development is done on other Windows machines; jobs are executed on dedicated UNIX server), I was wondering whether I need the ...