Re: MCH1201 (Rcvr too small) on an _if_ statement???

[Barbara Morris <bmorris@xxxxxxxxxx>]

Wilt, Charles wrote:
> Actually there are lots of invalid values for a 2B0 varible.
>
> 2b0 is treated as 4b0 (two bytes), and 4b0 is _NOT_ the same as 5i0 (two bytes).
>
> 5i0 has a range, -32768 to 32767
> 4b0 has a range, -9999 to 9999.

Actually, 2b is treated as 2b, and the range is -99 to 99.

Walden, I'm pretty sure that SQL supports the SQL null-indicator 
variables being defined as 5I.  Using 5I would avoid the RPG numeric 
overflow problem.

Just guessing now ... is the Pet_Name_Ind variable in a data structure, 
and it was used before it was set?  If so, it might have the default DS 
initialization value of blanks, x'4040' which is the integer value 
16448.  More guessing, that the SQL SELECT didn't find a record, and 
further guessing that embedded SQL doesn't update the host variables 
when it doesn't find a record.