Stored Procedures Types
1. External high level language procedures – COBOL, PL/I, C, C++, Assembler, REXX, and Java
2. External SQL language procedures
3. Native SQL language stored procedures – Introduced by DB2 9 for z/OS

• What is Native sql procedure ?
• What is the difference between External and Native SQL procedures?

In DB2 z/OS, a procedure created with LANGUAGE SQL resulting in the generated of code (I don't know which programming language, though). You had to bind a DBRM for that. With DB2 V9 for z/OS, DB2 stores the procedure in the DB2 catalog and executes it directly - such a "native" procedure has no longer the step over an external module and DBRM.