SQLPrepare and SQLNativeSQL escape sequences and scalar functions
The IBM® i Access ODBC support includes escape sequences and scalar functions.
ODBC has escape sequences and scalar functions that are used to avoiding having to code directly to the syntax of a particular DBMS's version of SQL.
See Microsoft's ODBC specification on how to use escape sequences. The following ODBC escape sequences are supported by the IBM i Access for Windows ODBC driver.
Escape sequences:
- d
- t
- ts
- escape
- oj
- call
- ?=call – This escape sequence should be used when trying to take advantage of the DB2® for IBM i support for return values from a procedure. The parameter marker will need to be bound as an output parameter using the SQLBindParameter API. Note, at this time procedures can only return values of type integer.