Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Unanswered: Help - SQL0519 Prepared statement S000001 in use

    I am also devloping software with the .NET provider and getting sporadic "SQL0519 Prepared statement S000001 in use." messages.

    We use two methods to retreive data from the iSeries in our applications, either direct SQL statments or calls to pre existing RPG programs (or rather, CL programs that in turn call RPG programs).

    This error only occurs when using direct SQL statements, and only on occasion. Once it has occurred, the call seems to stay blocked for about an hour and a half before working again.

    Has anyone else determined what causes this issue?

  2. #2
    Join Date
    Apr 2006
    Posts
    3
    Does anyone else have this issue?

    Could it be a resource issue with the iSeries?

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Without knowing much about iSeries, there's a chance that the error is caused by running several client sessions concurrently. They're calling the same external program, which may be attempting to open a cursor that has already been open by that same program.

Posting Permissions

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