CREATE FUNCTION MYSCHEMA.FUNCTION1(SEQNAME VARCHAR(100))
RETURNS CHAR(100)
LANGUAGE SQL
MODIFIES SQL DATA
------------------------------------------------------------------------
-- SQL UDF (Scalar)
------------------------------------------------------------------------
F1: BEGIN ATOMIC
DECLARE varsql CHAR(100);
SELECT CONCAT('SEQ=',CHAR(NEXTVAL FOR MYSCHEMA.LOAD_ID)) INTO varsql
FROM SYSIBM.SYSDUMMY1;
INSERT INTO MYSCHEMA.VSQLTEMP VALUES (varsql);
RETURN varsql;
END
The above function gives me the following error. I am new to writing UDFs.
This query runs fine in a SP but not in a UDF. Kindly help me out with the
solution:
[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "varsql" was
found following "HEMA.LOAD_ID))) INTO". Expected tokens may include:
"<space>". LINE NUMBER=16. SQLSTATE=42601