Functions
OpenSQL provides scalar and aggregate functions.
Function Support for Enterprise Access Products
The overall level of function support for each Enterprise Access product is listed in the OPENSQL_SCALARS entry of the OpenSQL Standard Catalog Interface catalog. The Standard Catalog Interface catalog is a read-only view built on the system catalog of the underlying DBMS. The OPENSQL_SCALARS entry, located in the iidbcapabilities catalog section, can be one of three values: 'NATIVE', 'FULL' or 'LEVEL 1'. The default value is 'NATIVE'. 'NATIVE' indicates only native DBMS scalar functions are supported. 'FULL' indicates full Ingres function support is provided. 'LEVEL 1' indicates some mapping of Ingres functions. When OPENSQL_SCALARS is set to 'LEVEL 1', an additional table, iigwscalars, is provided which shows support details for individual functions.
To further determine the level of support provided for specific functions, see the documentation for your Enterprise Access product.
Last modified date: 04/03/2024