× 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.  Home
  2. RPG400-L
  3. April 2014

RE: Using MIN in embedded SQL

Perhaps you can use something like this:


SELECT ordyr,count(*) FROM macfile WHERE ordyr =
(SELECT min(ordyr) FROM macfile )
group by moda


Regards



-----Original Message-----
message: 1
date: Thu, 10 Apr 2014 15:18:45 +0000
from: Michael Smith <msmith@xxxxxxxxxxxxxx>
subject: Using MIN in embedded SQL

Disclaimer: My knowledge of SQL, and embedded SQL is limited.

The following interactive SQL statement yields the following:
SELECT ordyr,count(*) FROM macfile WHERE ordyr between 2003 and
2013 GROUP BY ordyr

ORDYR COUNT ( * )
2,003 225
2,004 392
2,005 447
2,006 248
2,007 379
2,008 544
2,009 262
2,010 568
2,011 532
2,012 288
2,013 314

I need to be able to set an RPG program variable with the year
results(2003). Is this possible, if so, please provide a coding example.

TIA

Michael Smith



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.