11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iigwscalars Catalog
 
Share this page                  
The iigwscalars Catalog
The iigwscalars catalog contains an entry for each function that an Enterprise Access Product supports. This catalog is present only if the OPENSQL_SCALARS entry in the iidbcapabilities catalog section has a value of LEVEL 1. If this catalog is present in your database, it details the level of support provided for functions.
The information is stored in the following format:
Column Name
Data Type
Description
function_name
char(32)
Name identifying the function.
support
char(10)
This column has one of four values:
RESTRICT indicates this function is supported but with restrictions. A restriction may be as simple as requiring a literal value for a parameter, or may indicate a slight variation from the standard Ingres behavior for this function.
 
 
COMPAT indicates a native DMBS function exactly matches the Ingres function. No translation is performed.
TRANS indicates that the function is translated to the target DMBS SQL without restrictions.
NO indicates that a function is not supported.
parm1
char(10)
A value of LITERAL indicates that the first parameter to this function must be a literal value. A value of EXPR indicates that both literal values and expressions are allowed for this parameter.
parm2
char(10)
LITERAL or EXPR.
parm3
char(10)
LITERAL or EXPR.
mapping
varchar(253)
This column documents the target DBMS SQL that is generated when the Enterprise Access product does translations.
comments
varchar(400)
Comments.