DB2 V8 z/OS External SQL Procedure DSNHPC
Posted on 2008-10-13
We are running DB2 V8 on z/OS. I want to create an External SQL Procedure (SQL only; no cobol, etc). I have written the Create Procedure statement. The next step is to "Preprocess the Create Procedure statement by executing program DSNHPC, with the HOST(SQL) option." I can't find JCL for this (I found JCL for DSNHPC for a Cobol procedure, but not a SQL procedure). Can anyone share their JCL?