Hi Friends,
I try to use CPYFRMIMPF command to copy an excel file in the IFS folders to the Flat file present in the library.
The copy command is successful, but the datas are perfect junk data. ..
I got a suggestion to use the CSV file instead of XLS format.
But still the [problem persists.
Please could anyone suggest the way to copy an excel file from the iFS folder to flat file without any delimiters and correct data.
The command given by me is CPYFRMIMPF FROMSTMF('/home/t1.csv') TOFILE(QTEMP/TEST) RCDDLM(*CR)
Also tried using RPLNULLVAL etc
I try to use CPYFRMIMPF command to copy an excel file in the IFS folders to the Flat file present in the library.
The copy command is successful, but the datas are perfect junk data. ..
I got a suggestion to use the CSV file instead of XLS format.
But still the [problem persists.
Please could anyone suggest the way to copy an excel file from the iFS folder to flat file without any delimiters and correct data.
The command given by me is CPYFRMIMPF FROMSTMF('/home/t1.csv') TOFILE(QTEMP/TEST) RCDDLM(*CR)
Also tried using RPLNULLVAL etc
Comment