Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic WITH equivalent in Informix

‏2012-10-18T22:07:57Z |
Is there a WITH keyword equivalent in IBM Informix Dynamic Server Version 11.50.UC5XA?

For instance:

with tsource as
(select count(*) from enduser)
select * from tsource

This throws syntax error in Informix, but runs fine in Oracle 11g