Hi All,
I am loading records into database table using oracle enterprise stage with sql load options.
This datasatge job was not issuing any warning messages in the director log. today it started issuing a warning messages
"EmpLoadJob: When checking operator: Formatted length of fields and record (425) less than declared length (426)"
I have searched for this topic in all fourm but didnt get any satisfactory resolution.
Please tell me if somebody have faced and resolve this issue.
Regards,
Formatted length of fields and record
Moderators: chulett, rschirm, roy
Formatted length of fields and record
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The problem is between the keyboard and the chair. You have declared a record length of 426, and a set of column widths that total 425.
The "solution" is to get it right.
The "solution" is to get it right.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: