I need to Upload an excel file with (.xls format) from PC to iseries.
So I have changed to CSV format . I have created a folder in QDLS folder and i have placed the excel to QDLS folder using iseries navigator. So using following command i have copied all the records to Physical file.Its working fine.
CPYFRMIMPF FROMSTMF('QDLS/CONTRACT/TEST99.CSV') TOFILE(library1/CONTOUT) RCDDLM(*CRLF) STRDLM(*NONE) RPLNULLVAL(*FLDDFT)
1. I need to do the same without using iseries navigator and without converting it to CSV format(Comma delimited format).Please let me know.