Re: SQL Problem

-----Original Message-----
From: MWalter@hanoverwire.com <MWalter@hanoverwire.com>
To: rpg400-l@midrange.com <rpg400-l@midrange.com>
Date: Thursday, September 13, 2001 4:42 PM
Subject: SQL Problem


>If anyone has any information on why I'm receiving a sqlcod of -305
>(Indicator variable required) on a LEFT OUTER JOIN when there are
>non-matching primary records with the secondary record, I'd appreciate
>being left in on it. There aren't any indicator variables in the table. I
>didn't even think you could put indicator variables in a PF. At least using
>DDS.


did you not read my first reply?

not an indicator like *IN13, but an SQL indicator variable. A host variable
declared to receive an indication that the field is null. In any outer join,
records that don't have a match will be returned but the fields from the
record that is missing from the join will be returned as null. Any time you
have a null capable field returned in your program, you must code the null
indicator variable.

the variable is defined in your program, not in the file.

this is clearly described in the manuals.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman