Hello,

I am developing a udf in c.

When i try insert or update fields with udf in db2 i obtain this sqlcode "SQL CODE: -577"
This is the detail for sql code

SQLCODE -577, Error: ATTEMPTED TO MODIFY DATA WHEN THE DEFINITION OF THE FUNCTION OR PROCEDURE DID NOT SPECIFY THIS ACTION

I have tryied to modify the creation of UDF, i had added this tag "MODIFIES SQL DATA" but db2 print "sintax error"

This is the definition of this function

CREATE FUNCTION riz.VALIDA(in1 varchar(100) , in2 varchar(10))
RETURNS INTEGER
LANGUAGE c
PARAMETER STYLE sql
--MODIFIES SQL DATA --not works
FENCED THREADSAFE
NOT DETERMINISTIC
DISALLOW PARALLEL
NO EXTERNAL ACTION
EXTERNAL NAME 'ex!auth' ;

anyone can help me?

I think that the problem is the privilege

Thanks