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