×
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.
Thanks to everyone for their suggestions. I finally determined that the
problem is with the prepare statement. The procedure is not finding the
files unless I hardcode the library when I build the select statement. The
strange thing is that if I remove the prepare and hardcode the exact same
select statement that I'm building (without a library), I get the result
sets back.
I've never had to hardcode a lib in any of my other procedures, but this is
the first one I've had to use a prepare in. I still don't know how to
resolve this, but at least I'm looking at the right thing now (thanks to
Buck for the dump suggestion).
Linda
Buck wrote:
Are you running this interactively, or calling it via an ODBC/JDBC
connexion like Operations Navigator? When I do STRSQL and CALL one of
my working SPs, I get SQL7995 as well.
--buck
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.
midrange.com
