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



All you need to do is create a cursor with your SQL statement in it and
process the results of the cursor. There should be examples of cursors
in the archives.

Matt 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, June 09, 2006 3:19 PM
To: rpg400-l-bounces@xxxxxxxxxxxx; RPG400-l@xxxxxxxxxxxx
Cc: Midrange-l@xxxxxxxxxxxx
Subject: Embedded SQL within an RPGILE program


Hi everyone - I have a question.
I have a file DISKA, with the DDS as follows
FIELD-A        3
FIELD-B       30
FIELD-C      180
FIELD-D        5  5

Within STRSQL, I know you can type the following command
SELECT FIELD-B, FIELD-D, count(*) FROM DISKA GROUP BY
FIELD-B, FIELD-D ORDER BY FIELD-B, FIELD-D
and the result would be a display of unique groups with a count of
records
within each group.

Now my question is, how could I (if its possible)code this as embedded
SQL,
so that I can retrieve and display the data/results in a sub-file?

My experience with embedded SQL leaves a lot to be desired, and I'm not
too
sure how to handle this.

Thanks in anticipation



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.