DBCENTURY environment variable

If a String represents a DATE or a DATETIME value that has less than a three-digit year value, the HCL OneDB™ JDBC Driver uses the DBCENTURY environment variable to determine the correct four-digit year and performs a String-to-DATE or -DATETIME conversion.

The following table summarizes the affected methods and the conditions under which they are affected.
Table 1. Summary of affected methods and conditions
Method Condition
IfxPreparedStatement.setString(String) The target column is SQLDATE or SQLDTIME.
IfxPreparedStatement.setObject(String) The target column is SQLDATE or SQLDTIME.
IfxPreparedStatement.IfxSetObject(String) The target column is SQLDATE or SQLDTIME.
IfxResultSet.getDate() The source column is a String type.
IfxResultSet.getTimestamp The source column is a String type.
IfxResultSet.updateString(String) The target column is SQLDATE or SQLDTIME.
IfxResultSet.updateObject(String) The target column is SQLDATE or SQLDTIME.
The following example shows a URL that uses the DBCENTURY environment variable:
jdbc:informix-sqli://myhost:1533:informixserver=myserver;user=myname;password=
mypasswd;DBCENTURY=F;

You must specify a valid URL on a single line.