SQL guide For IBM Informix database servers 5.x, 7.x, 8.x, 9.x, 10.x, 11.x / Partially supported IBM Informix SQL features |
IBM® Informix® IDS provides several database extensions implemented with the DataBlade® Application Programming Interface, such as MQ Messaging, Large OBjects management, Text Search DataBlades, Spatial DataBlade Module, etc.
Genero BDL partially supports DataBlade modules:
SELECT id FROM products WHERE bts_contains( brands, 'standard' )
You can also use Dynamic SQL to perform queries with a syntax that is not allowed in the static SQL grammar.