> What do other DBs do with their output variables if there is > an embedded SQL > query resulting in a NULL return value? What I mean is: > > exec sql select text into :txt:ind from ... > > If text is NULL, ind will be set, but does txt change? > > I was just told Informix blanks txt. No, it gives a null string. In general Informix has a value that represents null that is 'distinct from all legal values in any given datatype'. Andreas