
EC stored procedure demo files:
  - Database Stored Procedure:
    - GETNAMES.CBL         -- COBOL main program
    - getnames.java        -- Generated Java from Elastic COBOL compiler, compiler options shown in-line
    - GetNames.jar         -- Compiled java together with Elastic COBOL runtime library
  = Client Driver Program:
    - EXECNAMES.CBL        -- COBOL main program
    - execnames.java       -- Generated Java from Elastic COBOL compiler, compiler options shown in-line
    - ExecNames.jar


Adjust the following for installation into SpliceMachine:
   CALL SQLJ.INSTALL_JAR('/path/to/GetNames.jar', 'ADMIN.GETNAMES', 0);
or
   CALL SQLJ.REPLACE_JAR('/path/to/GetNames.jar', 'ADMIN.GETNAMES');
and
   CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath','ADMIN.GETNAMES');

DDL to define the stored procedure for Derby / Splice:

   CREATE PROCEDURE ADMIN.GETNAMES (
                  IN  STARTNM CHAR(10),
                  OUT OUT_CODE INTEGER
   )
   LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA DYNAMIC 
   RESULT SETS 2 
   EXTERNAL NAME 'getnames.callSp';


This SP assumes the following table and data are also defined:
    CREATE TABLE NAMES(NAME CHAR(10));
    INSERT INTO NAMES VALUES('fred');
    INSERT INTO NAMES VALUES('barney');
    INSERT INTO NAMES VALUES('wilma');
    INSERT INTO NAMES VALUES('betty');


Run this test with the command:
    java -cp ExecNames.jar:/path/to/splicedriver-1.5.2.0-SNAPSHOT.jar execnames


Result of this test:
    CALL GETNAMES() PASSED WITH OUT-CODE 000022+

    RECORDS BEFORE 'gggggggggg':
      fred      
      betty     
      barney    

    RECORDS AFTER 'gggggggggg':
      wilma       
    pass

