SQLJ - 2

• CREATE PROCEDURE wrapper

  • Refers to external Java method
  • Supports Java result sets
  • CREATE PROCEDURE procname()
    DYNAMIC RESULT SETS 1
    
    EXTERNAL NAME
    'classname.methodname (Ljava.sql.ResultSet)V'
    
    LANGUAGE JAVA

Previous slide

Next slide

Back to first slide

View graphic version

The EXTERNAL NAME syntax is a relatively new addition to ASA, and it's probably going to be improved and/or clarified in later releases.