Fixed width file
Moderators: chulett, rschirm, roy
Fixed width file
I have trying to define a fixed width (length 89) file (each line terminated by DOS line) with the following options :
Record delimiter string = DOS format
Record length = fixed
Final delimiter = end
Field delimiter = none
Field Quote = none
I am getting the following error while trying to view data in a Sequential file.
"record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "BILL_TYPE".
Please let me know where to set the field format as fixed.
Thanks
Record delimiter string = DOS format
Record length = fixed
Final delimiter = end
Field delimiter = none
Field Quote = none
I am getting the following error while trying to view data in a Sequential file.
"record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "BILL_TYPE".
Please let me know where to set the field format as fixed.
Thanks
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You might need to redefine your fields as CHAR of fixed width.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
You might need to redefine your fields as CHAR of fixed width.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
All the fields are CHAR fields only.
Please tell me onething.I have my original Table definition (in the Table Definition\Sequential folder) different than this.Once I load the definition into the Sequential File stage I am making those modification.So, do I need to change the original Table definition with those.
Please tell me onething.I have my original Table definition (in the Table Definition\Sequential folder) different than this.Once I load the definition into the Sequential File stage I am making those modification.So, do I need to change the original Table definition with those.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have you imported the metadata (table definition) for this file into DataStage so that you can specify the column widths and the fact that it is a fixed width file from the outset?
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.