I have cpy the fiel to csv file using command Cpytoimpf..
CPYTOIMPF FROMFILE(ARCPGM/&QFLENM) TOSTMF(&CSVDIR) +
MBROPT(*ADD) STMFCODPAG(*PCASCII) +
RCDDLM(*CRLF) DTAFMT(*DLM) NULLIND(*YES).
As this file when we are loading in oracle server...it is not loading few bad records,bad records are created due to double quotes,comma in middle of the string field.
Is there any common or dynamic program which we can write in RPGLE or CLLE.where we can read the table check for the special characters for each and every fields.
pls let me know ur thoughts on this...thanks for ur help.
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!