skolusu wrote: hvats83 wrote:
What is the RECFM of the file? Fixed Block (FB ) or Variable Block(VB) ? If it is VB then you need to add 4 to the position of price and quantity to account the RDW.
RECFM of file is FIXED block with record size = 100 bytes
well if your input is indeed FB, then the data you show as input is incorrect. You said everything is zero but the are values in between. How do you explain that?
Input file is FB filw with record length = 100 bytes.
There are two comp-3 fields in the record -
1.Price field definded as S9(12)V9(6) COMP-3 and it starts from 49th position
2.Quantity field definded as S9(12)V9(6) COMP-3 and it starts from 59th position
The price field is zero for every record in input file.
Problem I am facing is - while converting price field from comp-3 to display format I am getting 020202020202.020202 in output file.Since all price fields are zeros in input file , output file should have 000000000000.000000 in price field column