Hi All,
We facing one data related issues while loading data from Sequential file to Database.
Jobs design is like
Seq File------------>Target db(Oracle)
We are geting records like
1) "364237",5/31/2010 0:00:00,"PERIMETER CENTER LOFTS LLC","00001316","CRE"
Above mentioned is correct record and working fine.
2) "373466",5/31/2010 0:00:00,"PLAZA 111
(CARDINAL REAL ESTATE INVESTMENTS)","00000941","CRE"
this one is not proper record because there is one additional line in cloumn three and due to which job fails. We want to reject that record and make the job work.
Handling Data in Sequentail file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Scroll right in the Columns grid and you will find a property called something like "field contains terminators". Set this to true and your problem will vanish, provided that string fields are all correctly quoted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.