4.2 ʾһCREATE PROCEDUREʾʹһЩѡ
CREATE PROCEDURE INSERT_JAVASP (IN INPUT1 CHAR (10) INPUT2 CHAR (15))
SPECIFIC INSERT
DYNAMIC RESULT SETS 0
DETERMINISTIC
LANGUAGE JAVA
PARAMETER STYLE JAVA
NO DBINFO
FENCED
THREADSAFE
MODIFIES SQL DATA
PROGRAM TYPE SUB
EXTERNAL NAME 'INSERT_JAVASP!INSERT_JAVASP'
;

4.3 SQL4301 rc=0ĵ1ӣsqlcodeΪSQL4301Ϊ0ȣWindowsƽ̨ϵINSERT_JAVASP.java

D:\>javac INSERT_JAVASP.java

D:\>copy INSERT_JAVASP.class "C:\Program Files\IBM\SQLLIB\Function"
        1 file(s) copied.

D:\>db2 -tvf Create.ddl
CREATE PROCEDURE INSERT_JAVASP (IN INPUT1 CHAR(10) INPUT2 CHAR(15))
SPECIFIC INSERT
DYNAMIC RESULT SETS 0
DETERMINISTIC
LANGUAGE JAVA
PARAMETER STYLE JAVA
NO DBINFO
FENCED
THREADSAFE
MODIFIES SQL DATA
PROGRAM TYPE SUB
EXTERNAL NAME 'INSERT_JAVASP!INSERT_JAVASP'

DB20000I  The SQL command completed successfully.

D:\>db2 call INSERT('00012', '01034')
SQL4301N Java or .NET interpreter startup or communication failed, reason code "0".
SQLSTATE=58004 

