null_field length (0) must match field's fixed width (14)
Moderators: chulett, rschirm, roy
null_field length (0) must match field's fixed width (14)
Hi All,
I am getting this error:
Ci_FileSchema: At field "DT_CREA": "null_field" length (0) must match field's fixed width (14)
Ci_FileSchema is an import stage.In our project we are enabled the run time coloumn propagation,Here is not showing any metadata only single coloumn is used like 'Data'.It Passed data for all the coloumn values
The datatype is Timestamp. What value do I give for Null Field Value?
Thanks in advance.
Sridhar
I am getting this error:
Ci_FileSchema: At field "DT_CREA": "null_field" length (0) must match field's fixed width (14)
Ci_FileSchema is an import stage.In our project we are enabled the run time coloumn propagation,Here is not showing any metadata only single coloumn is used like 'Data'.It Passed data for all the coloumn values
The datatype is Timestamp. What value do I give for Null Field Value?
Thanks in advance.
Sridhar
Reddy
In the definitions of your import stage (is this a "column import" stage?) you will have incorrectly set the null_field length to 0, which is not allowed in a fixed-width timestamp field. Since this is a strictly typed field, you will have to supply a legal timestamp string value as the default.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Right click on the row in the Columns grid and choose Edit Row.
In the Nullable folder add "Null Field Value" from the Available properties to add. This is where you can set the null field value. It must be a valid timestamp, such as 9999-12-31 23:59:59
In the Nullable folder add "Null Field Value" from the Available properties to add. This is where you can set the null field value. It must be a valid timestamp, such as 9999-12-31 23:59:59
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: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai