CC_ORA_DEFAULT_DATETIME_DATE

Set this environment variable to specify the default values for the month, day, and year when the connector writes from a InfoSphere DataStage Time type to an Oracle DATE or TIMESTAMP column.

The format is YYYY-MM-DD where YYYY represents years, MM represents months and DD represents days. When the environment variable is set, the stage uses the value that is specified for the default year, month and day portion of the target values.

When the environment variable is not set, the month, day, and year to the current date in most scenarios. If the DRS Connector stage is used and the write mode is not bulk load, the month, day, and year are shown as 0000-00-00.