-
Sql0746n
Hi,
I have a function which is calling another function.
Both functions are declared with MODIFIES SQL DATA.
When executing the function, I receive an error message.
SQL0746N Routine "FUNC2" (specific name "SQL101118132755900") violated nested SQL statement rules when attempting to perform operation "MODIFY" on table "T2".
Functions
========
CREATE OR REPLACE FUNCTION FUNC1(v1 INTEGER, v2 INTEGER)
RETURNS INTEGER
MODIFIES SQL DATA
BEGIN
DECLARE vId INTEGER;
DECLARE Temp INTEGER;
-- Copy all the fields of the compound
SELECT ID INTO vId FROM FINAL TABLE
(INSERT INTO T1(
Name)
SELECT Name
FROM T1
WHERE Id = v1);
SET Temp = FUNC2(vId);
RETURN vId;
END \
CREATE OR REPLACE FUNCTION FUNC2(v1 INTEGER)
RETURNS INTEGER
MODIFIES SQL DATA
BEGIN
DECLARE vId INTEGER;
-- Copy all the fields of the compound
SELECT ID INTO vId FROM FINAL TABLE
(INSERT INTO T2(
Name)
SELECT Name
FROM T2
WHERE Id = v1);
RETURN vId;
END \
Kindly is there any way to get rid of this problem.
Thanks in advance.
Regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|