Hi Sri, Yes, I took a few shortcuts!
If I were to build a complete solution, I would parse the attributes and dynamically build the file tailoring skeleton. The underlying data comes from CA (Broadcoms) Datacom sample database. I expect that similar table extracts may be required for porting to other environments. The Datacom product range has many tools to facilitate this. Their Datadictionary utilities can produce a variety of copy book definitions and some of these provide a simpler mapping to attributes of columns in a table. That would be my approach to build a general solution. Your sort solution is great though... On Fri, Mar 25, 2022 at 12:38 PM Sri h Kolusu <[email protected]> wrote: > >>"&F1","&F2","&F3","&F4",&F5,&F6 > > Wayne, > > Isn't this assuming that the first 4 columns are character and you are > embedding the quotes ? Also did you delete off the first 2 records (the > headers and column attributes) ? > > I believe Op's requirement is to determine the column attributes based on > the 2nd record of the file and add quotes based on the requirement. > > Thanks, > Kolusu > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > -- Wayne V. Bickerdike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
