When data is fixed format
1)Format
Record level
Record length = fixed
Field defaults
Delimiter = none
The first recod is correct remaing rows are cmng zero or unmatched data.
The same data can be read in differnt format
2)Format
Record level
Final delimiter = end
Field defaults
delimter = none
the outcome of this result correct.
When u select fixed format its showing wrong data, If u select second method its showing correct data.
can anyone tell why it is?
thanks
BMSK
Why it is in Sequntial stage? When u read data Fixed format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In short because your data do not match your metadata in the first case. Without seeing examples of your data and your record schema(s) it is not possible to comment further.
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.
Hi Ray,
here the input data
the metadta colum are
rectype(1)
accnum(3)
sal(5)
tran(3)
Input data is
123450000400
134525000500
234510000300
312445000200
the out of Fixed format is
When go for the first method
rectype acc sal tran
1 234 50000 400
0 0 23451 0
0 300 267 830
0 3 0 124
When go for the second method
rectype acc sal tran
1 234 50000 400
1 345 25000 500
2 345 10000 300
3 124 50000 200
thanks
BMSK
here the input data
the metadta colum are
rectype(1)
accnum(3)
sal(5)
tran(3)
Input data is
123450000400
134525000500
234510000300
312445000200
the out of Fixed format is
When go for the first method
rectype acc sal tran
1 234 50000 400
0 0 23451 0
0 300 267 830
0 3 0 124
When go for the second method
rectype acc sal tran
1 234 50000 400
1 345 25000 500
2 345 10000 300
3 124 50000 200
thanks
BMSK