SQL Escape Sequences

Language features, such as outer joins and scalar function calls, are commonly implemented by database systems. The syntax for these features is often database-specific, even when a standard syntax has been defined. ODBC and JDBC define escape sequences that contain standard syntaxes for a number of language features.

The escape sequence is recognized and parsed by the OpenAccess SDK SQL engine or the third-party SQL engine.

The following language features are supported when using the OpenAccess SDK SQL engine with an OpenAccess SDK Client:

• Date, time, and timestamp literals
• Scalar functions such as numeric, string, and date type conversion functions
• LIKE predicate escape characters
• Outer joins
• Procedure call escape sequences

A third-party SQL engine may support these language features with the ODBC Client and the JDBC Client. Refer to the documentation for the language features supported by your third-party SQL engine.

The escape sequence used by JDBC is:

{extension}