Hi,
How do we define a Fixed Width Format for a Target File?
What all options do we select?
Regards,
Deepa
How to define Fixed Width Format for a Target File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
One of the sequential file settings is for fixed width output, then make sure you don't have any VarChar() columns.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The easiest way is while importing the table definition of that file (assuming it exists) or creating the table definition (assuming it doesn't exist). Record the width of each field, which is stored in the Display Width field.
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: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
Its currently throwing these errors:
1)Error when checking operator: Unable to initialize the exporter.
or
Error when checking operator: Export validation failed.
2)Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "cust_name".
3)Error when checking operator: At field "cust_state": "null_length" may only be used in conjunction with prefix length or link length
Error when checking operator: At field "rating": "null_length" may only be used in conjunction with prefix length or link length
Error when checking operator: At field "numb": "null_length" may only be used in conjunction with prefix length or link length
The source has datatype Varchar, but in the file, while importing metadata, I changed Varchar to char.
Any solution?
1)Error when checking operator: Unable to initialize the exporter.
or
Error when checking operator: Export validation failed.
2)Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "cust_name".
3)Error when checking operator: At field "cust_state": "null_length" may only be used in conjunction with prefix length or link length
Error when checking operator: At field "rating": "null_length" may only be used in conjunction with prefix length or link length
Error when checking operator: At field "numb": "null_length" may only be used in conjunction with prefix length or link length
The source has datatype Varchar, but in the file, while importing metadata, I changed Varchar to char.
Any solution?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: