• No replies
18 Posts

Pinned topic Issue on extract DATE field from oracle

‏2013-07-11T14:57:18Z |

Hi all,

it seems to be a wrong extraction data format.

Data field named DATAEMISSIONE in Oracle database is valued by "30-nov-0002 12:00:00", but the format in isidedba_enelmgesedoc.txt.load.000 is "0000-2-11-30 00:00:00".

During the LOAD operation the rows having the wrong data format are rejected.

Attached files:

RECORD_ENELMGESEDOC.txt file contains Oracle data extracted by OEM

isidedba_enelmgesedoc.txt.load.000 file contains rejected rows

enelmgesedoc.txt file contains table structure

db2load.sql file contains LOAD's command


Thanks in advance for your contribution