Troubleshooting
Problem
User-defined sql shows use of to_char - TO_CHAR(Date column, 'YYYY-MM-DDHH24:MI:SS')
Resolving The Problem
Add the following environment variable to the project. You can add this as a user-defined environment variable in DataStage Administrator DS_NO_FF = 1.
If DS_NO_FF is set to the value of 1, the Oracle DATE data types are imported as DataStage Timestamp column SQL types and fractional seconds are not supported. If fractional seconds are required then DS_NO_FF should not be set to 1.
NOTE - It may be necessary to also add this in dsenv if you call before and/or after job sql scripts.
At release 7.5.3 and higher the ORAOCI supports timestamp . This means a timestamp sql value will look like SELECT TO_CHAR(HIT_DATE, 'YYYY-MM-DD HH24:MI:SS') but DataStage
appends .FF at run time versus in a user defined it will not append this conversion.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21429040