LANGUAGE SQL

From SQL PL Guide for DB2

LANGUAGE SQL clause

This clause is used to specify the the stored procedure is written in SQL PL and not in an external language. The parameter is optional if your're using SQL PL.

Example:

CREATE PROCEDURE myproc
LANGUAGE SQL
BEGIN
    ...statements...
END!