2
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;
/
