SQL0104N An unexpected token"" was found following"". Expected tokens may:"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Amjad Raza Gill
    New Member
    • Dec 2010
    • 2

    #1

    SQL0104N An unexpected token"" was found following"". Expected tokens may:"

    I am facing this problem during the migration from oracle to db2, pls. help to remove this error. I am new to DB2.
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "" was found following "". Expected tokens may
    include: "". LINE NUMBER=27. SQLSTATE=42601


    CONNECT TO MIGT USER db2inst USING db2inst;
    SET CURRENT SCHEMA = 'CS611';
    SET PATH = SYSTEM PATH, "CS611";
    CREATE OR REPLACE PACKAGE PAYMENT_MANAGEM ENT IS
    --PDA *
    --PDA Created by : Wael Fahmy
    --PDA Date Created : 29 01 2007
    --PDA Version : 1.0
    --PDA Description :
    --PDA This package is used for Payment management and an interface for the TABS API
    --PDA
    FUNCTION APIPAY( Consubflag CHAR
    ,Contrno CHAR
    ,Username CHAR
    ,Paymode CHAR
    ,Chqdetails CHAR
    ,Carddetails CHAR
    ,Equipdet CHAR
    ,Invdetails CHAR
    ,Advdist CHAR
    ,Checksubscribe r CHAR
    ,Currency CHAR
    ,Payment_For CHAR
    ,Pay_Future_inv ocies CHAR
    ,IsDepositRefun d CHAR
    ,IsAdvancePayCo ntrno CHAR
    ,InRecieptNo CHAR
    ,additional_par ams CHAR -- agaleel for Back Dated transactions and OnBehalfOf
    ) RETURN VARCHAR2;
    FUNCTION paySubscriber( p_Area IN VARCHAR2 DEFAULT '0'
    ,p_SubscrType IN VARCHAR2 DEFAULT 'G'
    ,p_Subno IN VARCHAR2
    ,p_Amount IN NUMBER
    ,p_Username IN VARCHAR2
    ,p_PaymentInfo IN PAYMENTINFOTBL
    ,p_Currency IN VARCHAR2 DEFAULT 'NULL'
    ,P_Payment_For IN VARCHAR2 DEFAULT 'NULL'
    ,P_Pay_Future_i nvocies IN VARCHAR2 DEFAULT 'N'
    , P_IsDepositRefu nd IN VARCHAR2 DEFAULT 'N'
    , P_IsAdvancePayC ontrno IN VARCHAR2 DEFAULT 'N'
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    ) return RESULTTBL;
    FUNCTION payContract( p_Contract IN VARCHAR2
    ,p_Amount IN NUMBER
    ,p_Username IN VARCHAR2
    ,p_PaymentInfo IN PAYMENTINFOTBL
    ,p_Currency IN VARCHAR2 DEFAULT 'NULL'
    ,P_Payment_For IN VARCHAR2 DEFAULT 'NULL'
    ,P_Pay_Future_i nvocies IN VARCHAR2 DEFAULT 'N'
    , P_IsDepositRefu nd IN VARCHAR2 DEFAULT 'N'
    , P_IsAdvancePayC ontrno IN VARCHAR2 DEFAULT 'N'
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    )return RESULTTBL;
    -- Modification by Muhammad Kashif Wateen-CR140785.B[Payments]
    FUNCTION payCustomer( p_Customer IN VARCHAR2
    ,p_Amount IN NUMBER
    ,p_Username IN VARCHAR2
    ,p_PaymentInfo IN PAYMENTINFOTBL
    ,p_Currency IN VARCHAR2 DEFAULT 'NULL'
    ,P_Payment_For IN VARCHAR2 DEFAULT 'NULL'
    ,P_Pay_Future_i nvocies IN VARCHAR2 DEFAULT 'N'
    , P_IsDepositRefu nd IN VARCHAR2 DEFAULT 'N'
    , P_IsAdvancePayC ontrno IN VARCHAR2 DEFAULT 'N'
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    ) return RESULTTBL;
    -- End Modification by Muhammad Kashif Wateen-CR140785.B[Payments]
    FUNCTION payMultipleSubs cribers( p_SubscriberInf o IN SUBSCRIBERSINFO TBL
    ,p_Username IN VARCHAR2
    ,p_PaymentInfo IN PAYMENTINFOTBL
    ,p_Currency IN VARCHAR2 DEFAULT'NULL'
    ,P_Payment_For IN VARCHAR2 DEFAULT 'NULL'
    ,P_Pay_Future_i nvocies IN VARCHAR2 DEFAULT 'N'
    , P_IsDepositRefu nd IN VARCHAR2 DEFAULT 'N'
    , P_IsAdvancePayC ontrno IN VARCHAR2 DEFAULT 'N'
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    )
    return RESULTTBL;
    FUNCTION payMultipleInvo ices( p_Contract IN VARCHAR2
    ,p_Username IN VARCHAR2
    ,p_InvoicesInfo IN INVOICESINFOTBL
    ,p_PaymentInfo IN PAYMENTINFOTBL
    ,p_Currency IN VARCHAR2 DEFAULT 'NULL'
    ,P_Payment_For IN VARCHAR2 DEFAULT 'NULL'
    ,P_Pay_Future_i nvocies IN VARCHAR2 DEFAULT 'N'
    , P_IsDepositRefu nd IN VARCHAR2 DEFAULT 'N'
    , P_IsAdvancePayC ontrno IN VARCHAR2 DEFAULT 'N'
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    )
    return RESULTTBL;
    FUNCTION PayOnSpot( p_OrderType IN VARCHAR2 ,p_Services IN SERVICESTBL
    ,Consubflag IN VARCHAR2
    ,p_Contract IN VARCHAR2
    ,p_Subno IN VARCHAR2
    ,p_SubscrType IN VARCHAR2
    ,p_Area IN VARCHAR2
    ,p_Username IN VARCHAR2
    ,Paymode IN VARCHAR2
    ,Chqdetails IN VARCHAR2
    ,Carddetails IN VARCHAR2
    ,Currency1 IN VARCHAR2
    ,P_ParamList in PARAMLISTTBL DEFAULT NULL -- agaleel for Back Dated transactions and OnBehalfOf
    )

    return VARCHAR2;
    FUNCTION InsertSpotLevel ( p_Services IN SERVICESTBL
    ,p_Subno IN VARCHAR2
    ,p_SubscrType IN VARCHAR2
    ,p_Area IN VARCHAR2
    )
    return VARCHAR2;
    END;
    /
  • Amjad Raza Gill
    New Member
    • Dec 2010
    • 2

    #2
    can any one help to solve this problem pls.

    Comment

    Working...