If not, I'd vote for pulling it out. That's a heck of a
reserve.
I am afraid of lots of user complaints, even if we had notalready used
TEMP.
reserved word, so that part seems to balance out. There is apparently
no basis in published standards for TEMP being a reserved word. And
btw it is not currently documented as a reserved word in
syntax.sgml...
possibility to do a
grammar trick.
The portability syntax that would be needed is only:
select * from table where ..... INTO TEMP _mytemp;
Your example had the into temp after the select list, which does
not work in informix.
Andreas