Skip to Content
0
Apr 15, 2009 at 11:48 AM

Creating Derived Tables in universe designer against Informix database

43 Views

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