Hi,
The following workflow for creating a simple derived table displays an error message.
-Launch designer
-Create a new or select an existing universe with a connection to an informix database
-Go to the menu bar and select "Insert"
-Choose "Terived Table"
-Do a simple select eg "select * from <tablename>"
-Result
:Exception: DBD, [Informix ODBC Driver][Informix]A syntax error has ocured. State: 42000
Anyone has any ideas?
Informix Dynamic Server 7.3
driver 2.8
Thanks for pointers
Ken