×
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.
select lgsesn, count(*) as hitcount
FROM anloga
WHERE LGSESN NOT LIKE '%ARCHIVE%'
group by LGSESN
order by LGSESN
There's a way to get both the detail, and the control breaks, with the
latest releases of sql. Not to be disparaging but I don't think you're
ready for that level though.
I've read "SQL/400 Developer's Guide" by Paul Conte and Mike Cravitz.
Copyright 2000. Ok, a little dated and doesn't include some of the newer
stuff but it will definitely help you. After all, it's a guide, not a
reference manual.
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
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
