In addition to the list of SQL99 keywords, the expression analyzer has been enhanced to support common database specific constructs. The limitations are in the list below:
o IBM DB2 extension limitations:
-
The CONCAT keyword in DB2 can be used as a function (supported) or as an
operator (not supported)
SELECT
CONCAT(first_name, last_name) FROM customer;
SELECT first_name CONCAT
last_name FROM customer;
o Oracle extension limitations:
-
Support for Oracle Text Literals is limited to the two single quotation
marks mechanism, like:
'Jackie''s
raincoat'
but not the Q/q alternative quoting mechanism,
like:
Q<'Jackie's
raincoat>'