Hi folks,
Iam getting the warnigs,when I was trying to extract the data from the sequential file to Oracle table via copy stage.
the following are the warnigns:
1)FF_ECO_EXT_SRC_REJ,0: Data string 'WMI,7,MES028
2010-1' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
2)FF_ECO_EXT_SRC_REJ,0: Field "PROCESS_DATE" delimiter not seen, at offset: 39
3)FF_ECO_EXT_SRC_REJ,0: Input buffer overrun at field "PROCESS_DATE"
4)FF_ECO_EXT_SRC_REJ,0: Data string 'TVV,8,MESO28
2010-1' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
but I need to execute the job without warnings...
please help me if any one of you know.
Immediate help is more appreciable..
Warning while Iam extracting the data from sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Mon Oct 25, 2010 6:09 am
- Location: Hyderabad
Warning while Iam extracting the data from sequential file
Thanks & Regards,
HARIRAM
Software Engineer
HARIRAM
Software Engineer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's easy enough. All you have to do is to prevent the warnings from being generated, by constructing your job design correctly.harivasireddy wrote: I need to execute the job without warnings...
For example, "WMI,7,MES028\n2010-1" is clearly not a date, but you have attempted to do some kind of date processing (or at least formatting) on this column.
It's also apparent that your data do not match your metadata.
These are the things you need to correct.
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.
Starting two threads for a same problem won't speed up resolution of your problem.
Moreover if your previous post Unable to read the dataset is resolved then mark it as resolved with the solution implemented so that could be useful later for other guys as well, else respond to that.
Don't leave them unattended and incomplete.
Moreover if your previous post Unable to read the dataset is resolved then mark it as resolved with the solution implemented so that could be useful later for other guys as well, else respond to that.
Don't leave them unattended and incomplete.
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai