I need to read and ‘separate’ a CSV format file into 55 fields. My problem is that the length of each record in the file can be up to 858 characters in length.
When I try something like the following, there is no problem.
1 #CSV-INPUT-REC (A253)
READ WORK FILE RECORD #CSV-INPUT-REC
SEPARATE #CSV-INPUT-REC INTO #A #B etc.
However NAT 3.1.5 on Z/OS does not allow the variable to be defined any larger and SEPARATE does not appear to work with group fields or arrays. For obvious reasons I would prefer to use the SEPARATE statement rather than a manual process.
Does anyone have any suggestions? Thanks in advance.