Hi All
I am getting the following error while inserting null values in to a fixed width seq file .I gave null feild value as *.The data type for the column is Char.
Error
------
Sequential_File_20: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "MEME_CK".
Thanks,
Girish
Error inserting null value to fixed width seq file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Null Field Value in a fixed width file must have the same length as any non-null data in that field. After all, that's what fixed width means - every value in the column - including the representation of null - has the same width.
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: 56
- Joined: Mon Oct 16, 2006 7:32 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
In the column definition tab of the output, go to the relevant key column, do an edit row. From the properties set the field width and padchar property accordingly. This will solve the problem.
I am wondering why is this happening to a char column , anyways try redoing the stage, That is how I solved it when I encountered this with a char column.
thanks,
Ajith
I am wondering why is this happening to a char column , anyways try redoing the stage, That is how I solved it when I encountered this with a char column.
thanks,
Ajith