Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Error in building Sp in DB2

    Hi all,,,
    can u pls let me know what is teh error in my stored proc.. the error states
    /***********************
    "DSN CON 3 ** ERROR ** The procedure name in the source does not match the routine name in parameter "
    /************************************

    refer to details below...

    Pls do let me know .. i am a SQL developer.. and new to db2.. theres no error list even at the ibm site..

    Thanks
    Hitesh

    IRNT.P_FR_R_GSTSRCHASMT - Build started.
    Calling the build utility SYSPROC.DSNTPSMP...

    STEP FILE SE LINE
    -------- -------- ------ ------------------------------------------------------------------------------------------------------------------------------------
    CON SQLP 1 1DB2 SQL PRECOMPILER VERSION 7 REL. 1.0 PAGE 1
    CON SQLP 2 0OPTIONS SPECIFIED: STDSQL(NO) CONNECT(2) FLAG(I) NOSOURCE SQLFLAG(STD) MAR(
    CON SQLP 3 0OPTIONS USED - SPECIFIED OR DEFAULTED
    CON SQLP 4 APOST
    CON SQLP 5 APOSTSQL
    CON SQLP 6 ATTACH(TSO)
    CON SQLP 7 CONNECT(2)
    CON SQLP 8 DEC(15)
    CON SQLP 9 FLAG(I)
    CON SQLP 10 HOST(SQL)
    CON SQLP 11 NOT KATAKANA
    CON SQLP 12 LINECOUNT(60)
    CON SQLP 13 MARGINS(1,80)
    CON SQLP 14 ONEPASS
    CON SQLP 15 OPTIONS
    CON SQLP 16 PERIOD
    CON SQLP 17 NOSOURCE
    CON SQLP 18 SQLFLAG(STD) NO SEMANTIC CHECKING
    CON SQLP 19 STDSQL(NO)
    CON SQLP 20 SQL(DB2)
    CON SQLP 21 NOXREF
    CON SQLP 22 DSNH700I I DSNHYCER THE FIPS STANDARD IS USED FOR FLAGGING
    CON SQLP 23 1DB2 SQL PRECOMPILER MESSAGES PAGE 2
    CON SQLP 24 0DSNH702I W DSNHYDRV LINE 1 COL 1 THE STATEMENT DEVIATES FROM THE SQL STAN
    CON SQLP 25 IRNT . P_FR_R_GSTSRCHASMT ( IN ID_"
    CON SQLP 26 1DB2 SQL PRECOMPILER STATISTICS PAGE 3
    CON SQLP 27 0SOURCE STATISTICS
    CON SQLP 28 SOURCE LINES READ: 34
    CON SQLP 29 NUMBER OF SYMBOLS: 33
    CON SQLP 30 SYMBOL TABLE BYTES EXCLUDING ATTRIBUTES: 3328
    CON SQLP 31 -THERE WERE 2 MESSAGES FOR THIS PROGRAM.
    CON SQLP 32 THERE WERE 0 MESSAGES SUPPRESSED BY THE FLAG OPTION.
    CON SQLP 33 242792 BYTES OF STORAGE WERE USED BY THE PRECOMPILER.
    CON SQLP 34 RETURN CODE IS 4
    CON SQLT 1 DSNH700I I DSNHYCER THE FIPS STANDARD IS USED FOR FLAGGING
    CON SQLT 2 DSNH702I W DSNHYDRV LINE 1 COL 1 THE STATEMENT DEVIATES FROM THE SQL STAN
    CON SQLT 3 E IRNT . P_FR_R_GSTSRCHASMT ( IN ID_"
    CON SQLT 4 CREATE PROCEDURE IRNT.P_FR_R_GSTSRCHASMT(IN ID_INTERNAL DECIMAL(13,0),IN CD
    CON SQLT 5 TE,IN DT_TAX_PD_END DATE)RESULT SETS 1 LANGUAGE SQL MODIFIES SQL DATA COLLID
    CON SQLT 6 ,,VADTCPIP&172.16.129.222:*)'P1:BEGIN DECLARE CURSOR1 CURSOR WITH RETURN FOR
    CON SQLT 7 EADER.CD_FORM,T_RTN_ASMT_HEADER.CD_FILING_STATUS,T _ASMT_DTL.TX_LINE_ITEM
    CON SQLT 8 LLECTION,T_FINANCIAL_TRANS.AM_LIABILITY FROM IRNT.T_ASMT_DTL AS T_ASMT_DTL,IRN
    CON SQLT 9 ASMT_HEADER AS T_RTN_ASMT_HEADER WHERE T_ASMT_DTL.ID_RTN_ASMT_SEQ=T_RT
    CON SQLT 10 ACTION=T_RTN_ASMT_HEADER.ID_TRANSACTION AND T_RTN_ASMT_HEADER.ID_INTERN
    CON SQLT 11 TAX=P_FR_R_GSTSRCHASMT.CD_TAX AND T_RTN_ASMT_HEADER.CD_FORM=P_FR_R_GS
    CON SQLT 12 R_GSTSRCHASMT.DT_TAX_PD_BEGIN AND T_RTN_ASMT_HEADER.DT_TAX_PD_END=P_FR
    CON SQLT 13 AX_PD_BEGIN ASC,T_RTN_ASMT_HEADER.CD_FORM ASC;OPEN CURSOR1;END P1
    CON SQLT 14
    CON SQLT 15 SOURCE STATISTICS
    CON SQLT 16 SOURCE LINES READ: 34
    CON SQLT 17 NUMBER OF SYMBOLS: 33
    CON SQLT 18 SYMBOL TABLE BYTES EXCLUDING ATTRIBUTES: 3328
    CON SQLT 19 THERE WERE 2 MESSAGES FOR THIS PROGRAM.
    CON SQLT 20 THERE WERE 0 MESSAGES SUPPRESSED BY THE FLAG OPTION.
    CON SQLT 21 242792 BYTES OF STORAGE WERE USED BY THE PRECOMPILER.
    CON SQLT 22 RETURN CODE IS 4
    DSN CON 1 *** DB2 V7R1 SQL Procedure Processor DSNTPSMP 1.15 (UQ72855 2003-01-10)
    DSN CON 2 Language conversion warnings and/or errors, rc=4
    DSN CON 3 ** ERROR ** The procedure name in the source does not match the routine name in parameter
    DSN CON 4 ** procedure name: IRNT.P_FR_R_GSTSRCHASMT
    DSN CON 5 ** parameter 2: P_FR_R_GSTSRCHASMT
    DSN CON 6 Function "BUILD" cannot continue.
    DSN Sum 1 Request: BUILD routine P_FR_R_GSTSRCHASMT did not complete.


    SYSPROC.DSNTPSMP - Returned +8
    IRNT.P_FR_R_GSTSRCHASMT - Build failed.
    IRNT.P_FR_R_GSTSRCHASMT - Roll back completed successfully.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278
    Hi hitesh,

    Please check for the following,

    Your DSN Settings in the Control Panel.

    Please also go thru the document for setting the Complier Path and ensure you have the necessary set.

    Hope these pointers help

    Nitin.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •