Hi,
I am getting the following error when sending a column from a database table to seq file.
Sequential_File_12: When checking operator: When validating export schema: At field "file_processing_start_time": "null_field" length (0) must match field's fixed width (19)
The mentioned file_processing_time is a column of timestamp data type having length 23.While running the job data is nt getting transferred due the above error.
Can anybody suggest what this error exactly specifying.
validating export schema
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because the file is defined as fixed width, the Null Field Value must have the same number of characters as a non-null value in that field. In this case, apparently, 19 characters. Nineteen space characters would do. Twenty-three character timestamp would NOT do. A zero-length string (""), which is what you currently have set, will NOT do.
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.