# rules for converting Informix SQL to DB2-compatible syntax
#
# WARNING: NOT COMPLETED YET
#

DOUBLE_TO_SINGLE_QUOTES
MATCHES_TO_LIKE
SELECT_INTO_TEMP_AS_DECLARE_INSERT
ADD_SESSION_TO_TEMP_TABLE
TABLE_ALIAS_AS
COLUMN_ALIAS_AS
EXPAND_COLUMNS
STRIP_QUOTES_FROM_OWNER

# - works, but not in all cases; DB2 does not recognize expressions
#   in form of set substr(col,2,3)='foo' (informix style is: set col[2,4]='foo')
SUBSTRING_FUNCTION = substr 
MONEY_AS_DECIMAL
STRIP_ORDER_BY_INTO_TEMP
REPLACE_COMMAND SET EXPLAIN ON = SET CURRENT EXPLAIN MODE YES
REPLACE_COMMAND SET EXPLAIN OFF = SET CURRENT EXPLAIN MODE NO

# UPDATE STATISTICS does not exist in DB2 UDB, so we have to ignore it
# first two forms should work, but not yet tested.
# The third one cannot be easily ignored in similar way, because of
# the table name at the end of the expression (wildcard support would
# be useful...)
#REPLACE UPDATE STATISTICS =
#REPLACE UPDATE STATISTICS FOR TABLE =
#REPLACE UPDATE STATISTICS FOR TABLE .... =

#
# WARNING: NOT COMPLETED YET
#