Results 1 to 2 of 2

Thread: Some UDF items

  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: Some UDF items

    All -
    in writing some User Defined Functions, I am getting this error




    SQL0101N The statement is too long or too complex.



    What I am doing is not that complex. Basically, performing 5 0r 6
    queries insude the UDF and setting them to a variable.
    Then parsing those variables using while loops and if statement to find a
    valid pay day within a pay month.

    It compiles file and loads into the database as well.

    When I invoke , I get this error message:

    db2 " select nextdraftday(34,' 214158052') from sysibm.sysdummy1"
    SQL0101N The statement is too long or too complex. SQLSTATE=54001


    The stmtheap parm is set to 8192 more than enough !


    Any assistance would be appreciated.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by java7man

    The stmtheap parm is set to 8192 more than enough !
    Obviously not.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •