Differences between calling stored procedures in DB2 and calling in Oracle

You can use exec or call to call a written stored procedure in Oracle data, but you can only use call to call the stored procedure in db2. Pay attention to parameter issues and parameter issues.

 

Exec proc_pay_idv ('20140901 ',?);

The execution reports an error. exec db2 does not contain keywords.

But if you use call

Call proc_pay_idv ('20140901 ',?);

Because call is a keyword

 

Below is a test stored procedure I wrote in db2 (you can check it)

Set schema DB2ADMIN;

Set current path = "SYSIBM", "SYSFUN", "SYSPROC", "SYSIBMADM", "DB2ADMIN ";

Create procedure "DB2ADMIN". "PROC_PAY_ORG"
(IN "IS_DATE" VARCHAR (10 ),
OUT "RET" INTEGER
)
SPECIFIC "DB2ADMIN". "sql140401092424900"
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
EXTERNAL ACTION
OLD SAVEPOINT LEVEL
MODIFIES SQL DATA
INHERIT SPECIAL REGISTERS
BEGIN

COMMIT;
Truncate table DB2ADMIN. PAY_ORG IMMEDIATE;

Insert into DB2ADMIN. PAY_ORG
SELECT
B. OU_CODE,
'',
IS_DATE,
A .*
FROM DB2ADMIN. BDW_ORG a inner join DB2ADMIN. BDW_DIM_OU B on a. open_ou_ip_id = B. ou_ip_id;

Set ret = 1;

END;