"The usage of "LEFT JOIN" in SQL-RPG Programs

["Acar GURSOY" <acarg@xxxxxxxxxxx>]

I have two files in relation master&details.

SPMAST (master file)  has records, SPRENK (detail file) has no record empty
file.

via STRSQL I can get all the records from first file when I use LEFT JOIN.

but via RPG code (same SQL statement) I can't get any record.

Might it depend on SQL Object Version (V4M4R0) or RPG Compiler parameters??


RPG-SQL code ;

C/EXEC SQL
C+ DECLARE C1 DYNAMIC SCROLL CURSOR FOR
C+ SELECT
C+ T1.GECREF, T1.SIPYY, T1.SIPREF,
C+ T1.SIPMIK, T1.FSKL,T2.BYM,
C+ T1.ITRMTR, T1.RVZNO,
C+ T1.AKRYY, T1.AKRREF, T1.DURUM
C+ FROM   OBJLIB/SPMAST AS T1
C+    LEFT JOIN OBJLIB/SPRENK AS T2
C+            ON T1.SIPYY  = T2.SIPYY  AND
C+               T1.SIPREF = T2.SIPREF AND
C+               T1.GECREF = T2.GECREF AND
C+               T1.RVZNO  = T2.RVZNO
C/END-EXEC


Thanks in advance...

Acar Gursoy
AS400 Programmer


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com