HP Nonstop sqlmx (SPJ) Stored Procedure in Javas Getting Started

Stored Procedure in Java (SPJ) HP Nonstop sqlmx, we can code Java program and regist it as a DB Stored Procedure, and then calling it. SPJ is a stored procedure whose body is a static Java method. The body is known as anSPJ Method. 1. Install JDK JDBC ... onto OSS evn;2. Create a class, the fuction must is " static", becuase we can access the method in the class without Instan Tiate.

2. publicclassHelloWorld{
4.     publicstaticvoid testFunc(int a,int b,String[] tst,int[] bigger){
6.  
8.         if(a > b)
10.            bigger[0]= a;
12.         else
14.            bigger[0]= b;
16.  
18.         tst[0]="The bigger one is: ";
20.     }
22. }

3. FTP the. java file onto OSS; 4. compile it with javac command; 5. regist, to register Spjs into MX,
    You must be either the schema owner or the Super ID. Run below script in mxci to reigist the stored procedure.

2. >>?SECTION "CREATE ENDER SPJs"
4. >>CREATE PROCEDURE sos.ecui.testFunc(IN param_a INT, IN param_b INT, OUT tst VARCHAR(20), OUT bigger INT)
6. +>EXTERNAL NAME ‘HelloWorld.testFunc‘
8. +>EXTERNAL PATH ‘/home/ecui/java/test‘
10. +>LANGUAGE JAVA
12. +>PARAMETER STYLE JAVA
14. +>MODIFIES SQL DATA;
16.  
18. --- SQL operation complete.
20.  
22. >> SHOWDDL SOS.ECUI.TESTFUNC;
24.  
26. CREATE PROCEDURE SOS.ECUI.TESTFUNC
28.   (
30.     IN PARAM_A INTEGER
32.   , IN PARAM_B INTEGER
34.   , OUT TST VARCHAR(20) CHARACTER SET ISO88591
36.   , OUT BIGGER INTEGER
38.   )
40.   EXTERNAL NAME ‘HelloWorld.testFunc (int,int,java.lang.String[],int[])‘
42.   EXTERNAL PATH ‘/home/ecui/java/test‘
44.   LOCATION \P3DEV.$DATA01.ZSDZSGJ5.MKN46G00
46.   LANGUAGE JAVA
48.   PARAMETER STYLE JAVA
50.   MODIFIES SQL DATA
52.   DYNAMIC RESULT SETS 0
54.   NOT DETERMINISTIC
56.   ISOLATE
58.   ;
60.  
62. --- SQL operation complete.

6. Grant privileges for invoking the Spjs and other users. 7. Call (or Invoke) the Spjs in sql/mx.  

2. >>CALL sos.ecui.testFunc(2,4,?,?);
4.  
6. TST                   BIGGER
8. --------------------  -----------
10.  
12. The bigger one is:              4
14.  
16. --- SQL operation complete.
18. >>CALL sos.ecui.testFunc(20,4,?,?);
20.  
22. TST                   BIGGER
24. --------------------  -----------
26.  
28. The bigger one is:             20
30.  
32. --- SQL operation complete.

 8. Delete this SPJ,

1. >>DROP procedure SOS.ECUI.TESTFUNC;
2.  
3. --- SQL operation complete.

From for notes (Wiz)

HP Nonstop sqlmx (SPJ) Stored Procedure in Javas Getting Started