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.
| 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.