DB2 user defined function problems

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tarun4j
    New Member
    • Sep 2011
    • 2

    #1

    DB2 user defined function problems

    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
Working...