I'm developing a simple server job.
Sequencial File -> Transform -> DataBase
Initially, DataBase stage i use OCI, but, to test, i change to ODBC.
Below sql in ODBC:
Code: Select all
UPDATE PCB_TABLE SET DATE_FINAL = ? WHERE (COD_UNIT = ? AND COD_CTO = ? AND COD_SCTO = ? AND COD_PL = ?);
The Sequencial File Input have a one record.
SF content - "1","00000042","00000000","398"
Transform stage create the column DATE_FINAL, carry "@NULL".
Conclusion, this "simple job" run forever.
Last line in log (Director):
"JOB_SEQ..ODBC_7: Using project default NLS map MS1252"
Anybody have a idea?