>> I have a 2-line header (column names, and column types) which indicates >> which are CHAR fields, but cannot figure out how to capture the information >> from the header to apply to the actual data lines. >> Is there a way to see which column type contains CHAR( -- each of the types >> is column separated -- and then be able to apply quotes to that particular >> output field? I am not sure about this, but hope there is an answer here. Don,
If your intention is to just enclose the character fields with double quotes, It can be done, however need couple of clarifications. 1. What is the LRECL and RECFM of the input dataset? 2. Looking at the data, it seems to comma separated data, however the 2nd header line that has the db2 column attributes has numeric fields which has the precision separated with a comma. Is there anything special to distinguish the attributes? What does N.N mean? Can I use that as separator? Thanks, Kolusu DFSORT Development IBM Corporation ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
