var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Does anyone else have this issue?
Could it be a resource issue with the iSeries?
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.