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 11.10 introduced a set of XML built-in functions when the idsxmlvp virtual processor is turned on. Built-in XML functions are of two types: Those returning LVARCHAR values, and those returning CLOB values. For example, genxml() returns an LVARCHAR(32739), while genxmlclob() returns a CLOB. XML data is typically stored in LVARCHAR or CLOB columns.
Genero BDL partially supports XML functions:
FUNCTION get_cust_data(id) DEFINE id INT, v VARCHAR(5000) SELECT genxml(ROW(cust_name, cust_address), "custdata") INTO v FROM customers WHERE cust_id = id RETURN v END FUNCTION