× 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.


  1.  Home
  2. MIDRANGE-L
  3. September 2005

RE: SQL Functions

Would enabling a scratchpad help with this?  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Friday, September 16, 2005 2:19 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Functions


I think your question is, if each of those functions does a
Select ... 
 from IIM
 into :ReturnVar
 where iprod=:item#
and you call all three will it end up doing three i/o's or just one?

I would hope it would all be buffered.  But, honestly, that's just a wag.

Perhaps there's some game you could play with your service program that 
would only actually 'get' the row on the first function that is executed. 
Then the other functions/subprocedures would somehow know that the ITEM# 
is not changed and would thus use some global variable or other technique 
to return the new value requested without an I/O.  Sort of like the getter 
and setter techniques.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.