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

Just guessing now ... is the Pet_Name_Ind variable in a
data structure, and it was used before it was set?

God I love Barbara. :-). Yes, the field is in a DS (for no good reason
other than it's there). It's not used prior to the sql statement, but
I'd say you're close enough to the problem. It's odd that it was fine in
production for several months before this happened, but things sometimes
go bump in the night. We're recoded slightly (5i0 and checking SQLCOD)
and we'll put it back in and keep our fingers crossed.

Thanks to all.

-Walden

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)