× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Problem with native driver
  • From: "Luther Ananda Miller" <luther.miller@xxxxxxxxxx>
  • Date: Mon, 7 Feb 2000 19:05:39 +0100
  • Organization: HYPERe

Can't open two results from the same stored procedure from the same database
connection:
Yep- this is a terrible limitation.

Let's say you have a customer on the phone and you want to open two
telephone bill detail screens at the same time (for two different months) ..
can't do it if the details come back from a stored procedure. Hey, isn't
that why we use GUIs? We opened a PMR on it ages ago and for the response
that it was a feature of the system and if we wanted it change we would have
to submit a request for enhancement.

If you need to do it, then you need to have either multiple versions of the
same SP which are really identical, or multiple connections from the same
app, or use SELECT statement directly. Maybe it would be possible to use
dynamic SQL in the stored procedure and random generate cursor names with
each call, but I haven't tried. Wish this was on the top list of AS/400
database things-to-do...

But I think this should only be a problem if you do it from the same
database connection?

Luther
  ----- Original Message -----
  From: cujo@us.ibm.com
  To: DUCRET Gilles (GVA)
  Cc: 'JAVA400-L@midrange.com' ; DES ROSIERS Daniel (GVA) ;
ewarne@us.ibm.com ; MAZY Herv (GVA)
  Sent: Monday, 7 February 2000 15:46
  Subject: Re: Problem with native driver



  I believe your problem is that stored procedures are not a multi-threaded
  resource.  (I don't really know a better way to phrase that, but I am sure
  there is one).

  You should be able to create a similar problem in a single stand alone
  program by doing this:

  1) get a conection
  2) get 2 statements
  3) execute the strored procedure with the first statement (keep the result
  set open)
  4) execute the stored procedure with the second statement
       ***I would think you are going to get an error about the cursor being
  already open at this point


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.