Results 1 to 2 of 2

Thread: Db2-sql0519n

  1. #1
    Join Date
    Jan 2003
    Posts
    47

    Unanswered: Db2-sql0519n

    Hi,
    We are using the java based stored procedure to access the data from db2. Rarely we are seeing the following error( I can't say on high load)

    SQL0519N The PREPARE statement identifies the SELECT or VALUES statement of the open cursor.

    According to the db2 documentation it is saying "The statement cannot be prepared ". What does it mean , do we need to use statements instead of prepared statements.

    Can I have any sujjestions please.

    Thanks
    Shri
    p.srinivasarao

  2. #2
    Join Date
    Aug 2002
    Posts
    35

    Re: Db2-sql0519n

    HI,

    DId you find the issue?.
    Isue what i got was because of connection problem.

    From,
    vasu

    Originally posted by palchuri
    Hi,
    We are using the java based stored procedure to access the data from db2. Rarely we are seeing the following error( I can't say on high load)

    SQL0519N The PREPARE statement identifies the SELECT or VALUES statement of the open cursor.

    According to the db2 documentation it is saying "The statement cannot be prepared ". What does it mean , do we need to use statements instead of prepared statements.

    Can I have any sujjestions please.

    Thanks
    Shri
    vasu

Posting Permissions

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