1 - If the new QAQQINI options are not in the Infocenter, then ding them.
Granted, you may get a response like I did about the SSD's that they may
cover it in the next release. Toughest thing is not the code - it's
translating the help, infocenter, etc into the plethora of languages
supported by IBM. :-)

2 - Is there any way you can fix the equation in SQL? I don't know if
it's applicable but moving stuff from the left to the right of a where
clause can help performance by using indexes (if available) but can also
avoid errors. For example, a coworker used to use
where NumToDate(numericdate) = current date
and changing that to
where numericdate = DateToNum(current date)
solved the issue with invalid dates (we also changed NumToDate to return a
null on an invalid date).

3 - Expanding further on functions, could you pass the numeric field to a
function to pass back a number?
select ...,
MyRpgFunctionToReturnANumberFromDecimalDataErrorField(PotentiallyBadNumber)
From ...
...
?


Rob Berendt

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