DSXchange

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

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.

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

Change the length of Record Length =Fixed to Record Length=12.