Using Escape Syntax

Escape syntax indicates information that must be translated from JDBC format to 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'}

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.