I have a flat csv format format file which I need to load in the DB
To conver the file in DB format using ENDBEFR=C';',FIXLEN=26 command in SORT JCL
Some of the fields are variable length in DB so I need to find the RDW
For eg input File Format
123445 34567890 AAAAAAA FFFFFFF
output file
Record 1 is FB
Record 2 is VB
Record 3 is VB
Record 4 is FB
Need to convert record 2 and 3 to VB to load the file in DB.
Please let know if this is possible with SORT JCL
Thanks
Sorry the data is char and Var char
Input file --> FB csv format
WOK.XXXX.D131122.XXXXXX.CSV
Code:
***************************** Top of Data ******************************
ABCDA1P;TXXXXXX1;CCCCCC01;DEDDDDD;N;;;;2015-01-05-00.00.00.000000
ANCDA1P;TXXXXXX1;CCCCCCC0;EEEEEEEEEM;N;;;;2015-01-05-00.00.00.000000
**************************** Bottom of Data ****************************
Quote:
Each record is comma seperated. column 2.3 and 4 are var char in the DB
Output File via FileAID : the length of variables fields are invalid
i.e 16448