Limitations on Database extensions

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:

• 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;
• 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>'