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.
March 16, 2011 9:12 AM
March 16, 2011 9:33 PM