RE: RPG SQL Question

Hi,
     Thanks for all the suggestions. I tried most of them, with mixed
results.
I can get the SQL to work properly in our query product, but I can't see
the statement it generates.
If I take out the secondary file, all the records print properly.
I added the check for null, and I got the previous line repeated instead of
the correct line.

Because of time, I decided to take out the left outer join, and just do a
chain to that file. Now it won't compile. This is code I am using:
C/EXEC SQL DECLARE A CURSOR FOR
C+  SELECT FPROD, FPBUYC, FQTY, FRDTE, FDATE
C+  FROM KFPL01
C+  WHERE FTYPE = 'F' AND FPBUYC IN ('G', 'F')
C+  ORDER BY FPROD
C/END-EXEC
C/EXEC SQL
C+  OPEN A
C/END-EXEC
C*
C                   DOU       MORREC = 'NO '
C/EXEC SQL
C+ FETCH A INTO :FPROD, :FPBUYC, :FQTY, :FRDTE, :FDATE
C/END-EXEC
C*
Error checking stuff
C     FPROD         CHAIN     ECLL04                             60

The error I get is *RNF7055 30    274 004700  Factor 1 FPROD is not valid
for the specified operation;
                           the specification is ignored.
FPROD is the field name in KFP. When I do the fetch, do I need to put it
into a field with a different name? FPROD is defined as 15A, the same as
the first key field in ECLL04.  I know I don't know much about SQL, but
this seams like it should be a no-brainer. Help


<===================================================>

Terri Harteau
****************
"There's no point in being grown up if you can't be childish sometimes."
- Dr. Who
****************

Original Post:
     I have this SQL statement in my program:

C/EXEC SQL DECLARE A CURSOR FOR
C+  SELECT FPROD, FPBUYC, FQTY, FRDTE, FDATE, LORD, LLINE, LRDTE, LSDTE
C+  FROM KFPL01
C+  LEFT OUTER JOIN
C+    ECLL01 ON LPROD = FPROD
C+  WHERE FTYPE = 'F' AND FPBUYC IN ('G', 'F')
C+    AND FRDTE > LRDTE
C+  ORDER BY FPROD
C/END-EXEC

I want to print all records that meet the criteria from KFP, and the
associated ECL information. There is one KFP record that has no associated
ECL record.  This record is not printing.  Both KFPL01 & ECLL01 are logical
files that contain only active records. The missing ECL record is coded as
inactive, so is in the file, but shouldn't be found using the logical. I've
never used the outer join before, but from what I have read, I thought this
would work. Any ideas on what I am doing wrong? Thanks!