0

I tried to create a stored procedure in SQLJ using IBM data studio and able to create the three types of files on building as xxx.class, xxx_Profile0.ser and xxx_ProfileKeys.class and placed the (.class) files in the below directory /QIBM/UserData/OS400/SQLLib/Function.

Created the stored procedure as

CREATE PROCEDURE XXXX.SQLJ_JAVA ( ) 
    LANGUAGE JAVA 
    SPECIFIC XXXX.SQLJ_JAVA 
    NOT DETERMINISTIC 
    NO SQL 
    CALLED ON NULL INPUT 
    EXTERNAL NAME 'sample.execution' 
    PARAMETER STYLE DB2GENERAL ;

While executing the procedure getting the exception below.

SQL State: 42724
Vendor Code: -4304
Message: [SQL4304] Java stored procedure or user-defined function SQLJ_JAVA, specific name SQLJ_JAVA could not load Java class SP for reason code 1.

Let me know if any thing goes wrong.

Buck Calabro
  • 7,558
  • 22
  • 25
Anto
  • 57
  • 2
  • 10

0 Answers0