Something seems troubling to me. This is a detail transaction file? Are
there other fields that would cause multiple occurances of your DISTINCT
fields in the table? Is there a header table and a detail table that work
in conjunction with each other? It seems that some sort of join would
work better here....
What was the SQL statement BEFORE the new feature???
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/06/2008 09:48 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Re: Puzzling SQL Statement
I don't know if this makes a difference, but we are on V5R3.
This mailing list archive is Copyright 1997-2019 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