Left Outer Join

[Guest.Visitor]

Roger, If you really just want to continue on and don't care that it is null, you can use the ifnull or coalesce function. You end up with something like: select field1, field2, ifnull(field3,' ') from filea left join fileb on filea.field1 = fileb.field1 That will ruturn a blank for a null value. If that is not OK, then you need to code an indicator area. An indicator area is an array of 2 byte integers. A negative 1 indicates a null value. I don't have an example handy right now, but if you need one I can post one later. David Morris

[Guest.Visitor]

Left Outer Join

I have a embeded sql left outer join in an RPG program. Some times the file that I have joined to will not have a record. This causes the fields form that file to be null when the record is fetched. How do I get the RPG program to handle the null fields? Thanks Roger

[Guest.Visitor]

Left Outer Join

Thanks that is exactly what I needed. I appreciate your help. Roger