Parameter Conventions

See the IBM DB2 documentation for external routine parameter styles.

Note: Because DB2 LUW passes information to and from the stored procedure, specify NATIVE when passing any numeric parameters. For example:

PROC(EMPNO, SQLCD)

   DECLARE EMPNO CHAR(6),                
           SQLCD FIXED BIN(31) NATIVE,