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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!