Hi 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...

Hi, I am sending data from iseries to excel through CPYTOIMPF i've used this command in CLLE, in query output there is a char field value is '01.03.2011' but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY QRY(ADO150Q) CPYTOIMPF FROMFILE(ADO150F)...

Hi frnds, I have two PF say as PF1 & PF2 and in the both files there are records such as Name, ADDR & PHNO: and now i want fetch data of repeated names in the both PF's. But without using RCVF command can we fetch records or data... Thanks

Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT + ...

hi , i am using a rpgle with display file , & calling a clp . in cl i am using SNGPGMMSG command , i just want to see the error messange on display screen, but its not showing , it is going somewhere else. i can see that error message in DSPJOBLOG. but it should display on display screen. is there...

I have a CL pgm in that i used the OVRDSPF command. Now i changed the display file. I'm sure i need to compile the RPG programs that are using the display file. Have a doubt if i need to compile the CL pgm or not?

Hi , I have a PF abc in my library ,now i want to move it to IFS directory /home/xzy. I am using CPYTOIMPF with TOSTMF option as /home/xzy/abc.txt but it is failing saying "The copy did not complete for reason code 11"..please help

I have certain users who never clean out their spool files. Is there any command I can run which will tell me how many spool files a user has out there? I am currently on version V5R4 of the operating system

We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy