Testing NotFound in SPL !%#$!!!!

Hi ALL! I'm working with SPL from few months and all goes fine (<g>), but I still have a little doubtful point. The question is: what is the correct way to test if a select returns no rows? In 4GL, I can test the Status variable for NotFound value (or test Sqlca.Sqlcode), but these variables don't exist in SPL (I believe!). I'm workarounding the problem by selecting a NOT NULL column and testing if the returned value is null, for example: SELECT col1 {not null column, usually the key}, col2, ... INTO c1, c2 ... IF c1 IS NULL THEN { means no rows found } .... Naturally, if I unfortunately have no NOT NULL columns, this method goes out. So, I'm thinking that the method is probably uncorrect..... :-| I have also tried with ON EXCEPTION IN (100), but on exception seems to work only on negative errors.... :-((( Another similar (and related) problem is: In 4GL: UPDATE foo SET.... IF SqlCa.SqlErrd[3] = 0 THEN INSERT INTO foo ... In SPL????? I actually do a select, test if row is found by the debatable method above (!!!!) and then I issue the insert (if not found) or update. Too much stress.... Help! ___*____ Ciao! | |_ e-mail (_|oe |or <joefor@iperv.it> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~