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

[darren@xxxxxxxxx]

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


Acar,
I wonder what type of join a LEFT JOIN is.  Is it a LEFT OUTER JOIN, or an
INNER JOIN?  Anway, either way you're in for trouble if there are no
records in the second file.  With INNER JOIN you'll get no records because
there is no match.  With a LEFT OUTER JOIN you could have problems in the
RPG because it doesn't handle NULL values very well, but in your case
you're not selecting any fields from the second file so I don't expect that
is the problem.  I would try specifying what type of join you're really
trying to do and see if that helps.  Its possible that if you are at
different OS levels that one version assumes a different kind of join than
the other.

Darren Strong
Programmer