×
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.
Wilt, Charles wrote:
Actually there are lots of invalid values for a 2B0 varible.
2b0 is treated as 4b0 (two bytes), and 4b0 is _NOT_ the same as 5i0 (two bytes).
5i0 has a range, -32768 to 32767
4b0 has a range, -9999 to 9999.
Actually, 2b is treated as 2b, and the range is -99 to 99.
Walden, I'm pretty sure that SQL supports the SQL null-indicator
variables being defined as 5I. Using 5I would avoid the RPG numeric
overflow problem.
Just guessing now ... is the Pet_Name_Ind variable in a data structure,
and it was used before it was set? If so, it might have the default DS
initialization value of blanks, x'4040' which is the integer value
16448. More guessing, that the SQL SELECT didn't find a record, and
further guessing that embedded SQL doesn't update the host variables
when it doesn't find a record.
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
