We would like to automate a file transfer, and I thought to use the cpyfrmimpf cl command.
The problem is that the .CSV file we wish to copy to our DB2 database has a header row that does not match the column data...some data must appear to the transfer as numeric. When I remove the header row, CPYFRMIMPF works perfectly.
When I code the CPYFRMIMPF COMMAND and request the copy begin at record #2 of the CSV file, the command chokes also. We would like to develop a transfer where no one needs to modify the .CSV file by removing or renaming the column headers so that the transfer completes. We are at V5R4