The SQL_SYNTAX setting is used to allow a limited set of Oracle specific functions or the SQLSERVER bracket syntax to be used within an Omnidex SQL statement. This setting can be sent via an ODBC or JDBC call and once set will be used for all subsequent Omnidex SQL statements until either reset or the session terminates.
SET SQL_SYNTAX <ORACLE | OMNIDEX | SQLSERVER >
The setting can be automatically set by using the CREATE_ENVIRONMENT statement's SQL_SYNTAX clause.
OMNIDEX is the default setting.
set sql_syntax ORACLE
select instr('123456', '4') from $omnidex;