also be aware that although "y" may return a value, it may NOT be valid. I had this discussion with support once.
they said that they claim to be able to do what that want with the variables (like "y") within the SQL procedures. when they finally pass back control to you (the programmer) its up to you to check the value of SQLCODE and then and ONLY then can you rely upon the value of the "into variables" kev
