Hi,
New in informix,need help for
__________________________________________________ ___________
"How to handle the return code from query in informix SPL and TRACE the message of the SQLCODE and resume the control after that " .i have many SQL statements and want to do it for each .
__________________________________________________ ____________
Thanx & Regards
upsingh

Hi,
Please read about ON EXCEPTION section and RAISE EXEPTION sintax.
Ex: RAISE EXCEPTION -746, 0, 'You broke the rules';

Gustavo.

I had it open on another window,
make something like this,
and put it after your defines and before your instructions

ON EXCEPTION SET error_num, isam_num, error_msg
trace 'Error at label : ' || label ;
trace 'Error: ' || error_num || ' ' || error_msg;
return -1 ;
END EXCEPTION;

on exception in (-239) SET error_num, isam_num, error_msg -- if record already exists
trace 'Warning at label=' || label || ' ' || error_num || ' ' || error_msg;
trace 'Record already exists, key is ' || v_key ;
trace 'Continue with procedure';
end exception with resume;

Thanx supinformix,
i am done with that and its working fine
ON EXCEPTION SET SQLERR,ISAMERR,ERRMSG
END EXCEPTION WITH RESUME