My sincere apologies Kolusu . I have updated the answers in-line
>> If header comes in to this file for whatever reason we need to skip and >> then build this filename Q. How do you distinguish the header ? Any indicator? You don't even show a sample. ***Header if comes will start with product_nbr >> The below fields remain the same for all the rows CompKey - 19 to 22 >> Position Patnum - 26 to 30 Position Q. You do realize that you did NOT use "Fixed Font or Courier New" font to retain the spacing in the sample data ? okay ********************************* Top of Data ************* .....0050425063|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .....0050996097|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .....0009077849|..4138|..12211|..00001.50|..000000001.50|.. .....0050761685|..4138|..12211|..00002.20|..000000013.20|.. .....0050124393|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .....0050997036|..4138|..12211|.. 0|.. 0|.. 0|.. 0| .....0009646052|..4138|..12211|..00001.24|..000000041.21|.. Q. What are the DCB properties of the input file and the output file? ** DCB of input will be Lrecl = 500 bytes and o/p will be 80 bytes >> Performdta_<Patnum>_<CompKey>_<yyyymmdd_hhmmss>.csv Q. Where are you getting the yyyymmdd_hhmmss value? Your sample input does not have it. Is it the CURRENT DATE and CURRENT TIME ? ** Yes it is current data and time >> o/p will be Performdta_12211_4138_20220620_192925.csv Q. Does your input always contain ONLY 1 Patnum+compkey combination ? What happens if you have another patnum+compkey combo ? ***1 file will have ONLY 1 Patnum+compkey combination Q. Is the patnum+compkey available on ALL records? Or does it vary? ** Yes all rows will have Patnum+compkey combination Thanks Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
