STORED PROCEDURE STAGE

[marpadga18]

I am executing a stored procedure from DataStage stored procedure stage

I am giving the following info in SYNTAX TAB

Procedure name: PKG_CLID_REQUEST.PRC_MAIN
Procedure Type: Transform
Check box checked in for GENERATE procedure call

The director log is below:

main_program: APT configuration file: /local/apps/DRS_dstage/IS81/IBM/InformationServer/Server/Configurations/default.apt
{
node "node1"
{
fastname "breus002"
pools ""
resource disk "/ds8/dataset1" {pools ""}
resource scratchdisk "/ds8/scratch1" {pools ""}
}
node "node2"
{
fastname "breus002"
pools ""
resource disk "/ds8/dataset2" {pools ""}
resource scratchdisk "/ds8/scratch2" {pools ""}
}
node "node3"
{
fastname "breus002"
pools ""
resource disk "/ds8/dataset3" {pools ""}
resource scratchdisk "/ds8/scratch3" {pools ""}
}
node "node4"
{
fastname "breus002"
pools ""
resource disk "/ds8/dataset4" {pools ""}
resource scratchdisk "/ds8/scratch4" {pools ""}
}
}

ST_Proc_PRC_CLID_REQUEST,3: Info: PRC_CLID_REQUEST.ST_Proc_PRC_CLID_REQUEST: BEGIN PKG_CLID_REQUEST.PRC_MAIN(); END;

ST_Proc_PRC_CLID_REQUEST,2: Info: PRC_CLID_REQUEST.ST_Proc_PRC_CLID_REQUEST: BEGIN PKG_CLID_REQUEST.PRC_MAIN(); END;

ST_Proc_PRC_CLID_REQUEST,1: Info: PRC_CLID_REQUEST.ST_Proc_PRC_CLID_REQUEST: BEGIN PKG_CLID_REQUEST.PRC_MAIN(); END;

ST_Proc_PRC_CLID_REQUEST,0: Info: PRC_CLID_REQUEST.ST_Proc_PRC_CLID_REQUEST: BEGIN PKG_CLID_REQUEST.PRC_MAIN(); END;

main_program: Step execution finished with status = OK.
main_program: Startup time, 0:01; production run time, 0:03.

The job is executing in finished status but in the director its executing 4 times it should execute one time only.
can any one faced this type of issue could share their ideas.

[chulett]

It will execute once per node unless you run the stage in Sequential Mode.

[marpadga18]

It will execute once per node unless you run the stage in Sequential Mode. ...

Thank's for your help!! it worked thx Chulett !!