Re: SPL: [SQL0443] JOB_STATUS_FILTER PARAMETER INVALID

[Rob Berendt <rob@xxxxxxxxx>]

Apparently using CALL QCMDEXC in a SPL forces you to change
         LANGUAGE SQL READS SQL DATA

SQL State: 2F002 Vendor Code: -577 Message: [SQL0577] Modifying SQL data 
not permitted. Cause . . . . . :   One of the following errors has 
occurred: -- A procedure was called or a function was invoked that was 
created with READS SQL DATA or CONTAINS SQL DATA specified as the data 
access attribute.  A procedure or function created with READS SQL DATA or 
CONTAINS SQL DATA, or any procedure or function that is called by the 
procedure or function, cannot change data and cannot call a procedure or 
function that has the MODIFIES SQL DATA attribute. -- READS SQL DATA and 
CONTAINS SQL DATA cannot be specified on the CREATE PROCEDURE, ALTER 
PROCEDURE, CREATE FUNCTION, or ALTER FUNCTION statements for an SQL 
procedure or function if the routine body contains statements that change 
data. -- A global variable default value used a function that changes 
data. Statements that change data include INSERT, UPDATE, DELETE, MERGE, 
REFRESH TABLE, GRANT, REVOKE, LABEL, COMMENT, and any CREATE, DROP, or 
ALTER statements. If the error occurred in a procedure or function, the 
routine name is QCMDEXC and the specific name is QCMDEXC. Recovery  . . . 
:   Ensure procedures or functions created with READS SQL DATA or CONTAINS 
SQL DATA do not call procedures or functions that change SQL data. Specify 
MODIFIES SQL DATA when creating functions that change SQL data.  The 
default value for a CREATE VARIABLE statement cannot modify SQL data.


Rob Berendt