Limitations of SQL query creation

This topic describes limitations of SQL query creation.

• A query cannot be created using a view that is derived from a user-defined function. This is a known limitation.

• Incorrect SQL is generated for a multitable data graph.

• Multitable graphs are not supported on Informix Dynamic Server 9.3.

• An error occurs when running an SQL file for a second time on Sybase 12 database. If you are running an SQL file on Sybase, change the Sybase SET CHAINED option to OFF.

 

Parent topic

Overview of SQL statements