The escape syntax
Escape syntax indicates information that must be translated
from JDBC format to HCL Informix® native
format. Valid escape syntax for SQL statements is as follows.
| Type of statement | Escape syntax |
|---|---|
| Procedure | {call procedure} |
| Function | {var = call function} |
| Date | {d 'yyyy-mm-dd'} |
| Time | {t 'hh:mm:ss'} |
| Limit | {limit number-to-limit} |
| Skip | {limit number-to-limit number-to-skip} |
| Timestamp (Datetime) | {ts 'yyyy-mm-dd hh:mm:ss[.fffff]'} |
| Function call | {fn func[(args)]} |
| Escape character | {escape 'escape-char'} |
| Outer join | {oj outer-join-statement} |
You can put any of this syntax in an SQL statement, as
follows:
executeUpdate("insert into tab1 values( {d '1999-01-01'} )");Everything inside the brackets is converted into a valid Informix® SQL statement and returned to the calling function.