Results 1 to 5 of 5

Thread: Error SQL0514N

  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Question Unanswered: Error SQL0514N

    Hi guys, i have this problem Exception occurred during replication.
    Unable to load bookmark data from database. The SQL error code is "-514". The SQL state is "26501". The SQL message is "DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURSH200C1, DRIVER=3.63.75".
    and i need to know whats is the meaning of this error.

    thankyou and regrads.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Is this from a DB2 server, or a MS SQL Server?

  3. #3
    Join Date
    Oct 2013
    Posts
    3
    it is DB2 Server

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've moved the message thread to the DB2 forum, it should get more useful answers here.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Code:
    db2 "? sql514"
    
    
    SQL0514N  The cursor "<name>" is not in a prepared state.
    
    Explanation:
    
    The application program tried to use a cursor "<name>" that is not in a
    prepared state. The cursor is associated with a statement that either
    (1) was never prepared, (2) was made not valid by a ROLLBACK, or (3) was
    made not valid by either an explicit or implicit rebind of the package.
    
    The statement cannot be processed.
    
    User response:
    
    For case (1), prepare the statement named in the DECLARE CURSOR
    statement for "<name>" before you try to open the cursor. For case (2),
    do not issue a ROLLBACK until after you finish using the cursor. For
    case (3), the prepare for the cursor must be reissued.
    
     sqlcode: -514
    
     sqlstate: 26501
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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