Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Problem building SQLJ Stored Procedure


    I am using DB2 Stored Procedure Builder version 7 to build SQLJ stored procedures on DB2 7.2 database.

    I am able to build a stored procedure. However if I change something and try to build again, I get the following error message.

    "This stored procedure is a JAVA stored procedure and found SQL source."

    "Build unsuccessful."

    I would appreciate if someone can help me figure out what is wrong.


  2. #2
    Join Date
    Dec 2002

    Re: Problem building SQLJ Stored Procedure

    I've seen the something similar with java stored procedures. I found that in some cases spb does not like word create in text (weird).
    So I replaced all create text with "cre" + "ate"(ulgly but it worked)
    Probably there are other "strange words".

    I was lazy to open a PMR with IBM, probably you can do it


Posting Permissions

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