skip to main content
SQL Escape Sequences
 

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}