× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.