hi, i had following user defined function in db2 and it is giving some problems as follows
CREATE FUNCTION READFILE(fileNa me VARCHAR(255))
RETURNS CLOB(1M)
//ERROR TOKEN MISPLACED CONSTRUCTS
SPECIFIC readFileToClob
EXTERNAL NAME 'library!readFi leToClob'
LANGUAGE C
PARAMETER STYLE SQL
DETERMINISTIC
NOT FENCED
RETURNS NULL ON NULL INPUT
//ERROR TOKEN MISPLACED CONSTRUCTS
NO SQL
NO EXTERNAL ACTION
NO SCRATCHPAD
//"_create_variab le" expected instead of this input
ALLOW PARALLEL
NO FINAL CALL;
could anyone tell me how to solve them
CREATE FUNCTION READFILE(fileNa me VARCHAR(255))
RETURNS CLOB(1M)
//ERROR TOKEN MISPLACED CONSTRUCTS
SPECIFIC readFileToClob
EXTERNAL NAME 'library!readFi leToClob'
LANGUAGE C
PARAMETER STYLE SQL
DETERMINISTIC
NOT FENCED
RETURNS NULL ON NULL INPUT
//ERROR TOKEN MISPLACED CONSTRUCTS
NO SQL
NO EXTERNAL ACTION
NO SCRATCHPAD
//"_create_variab le" expected instead of this input
ALLOW PARALLEL
NO FINAL CALL;
could anyone tell me how to solve them