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.
STORED PROCEDURE STAGE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
STORED PROCEDURE STAGE
Thanks,
M
M
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am