Answer / justin lopes

Use the command as follows on Physical file

CPYTOIMPF FROMFILE(LIBRARY/FILENAME) TOSTMF('/QDLS/TEMP/TEST.CSV') +
MBROPT(*REPLACE) FROMCCSID(37) +
STMFCCSID(*PCASCII) RCDDLM(*CRLF) FLDDLM(',')

Answer / samul

Reshma,

Thanks for info.

Can u plz eloberate this wiht exapmle ,it will be helpful
for me.

Thanks ,
Samul

Answer / reshma

Hello
To create a .csv file

u need to use command cpytoimpf on the file.

If u want it copy to a folder then
CPYTOPCD with .CSV extension

Thanks
Reshma

can anybody explain significance of *loval setll with example code????

3 Answers   HSBC,

---

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,

---

Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir

2 Answers   iGate,

---

Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.

1 Answers   CTS, IBM, iGate,

---

Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?

1 Answers  

---

---

what was the robotech rpg?

0 Answers   IBM,

---

How can we make use of SETLL operation in CL?

11 Answers  

---

what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,

---

Delete FileName at first statement in RPG.

1 Answers  

---

Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the significance of *MAP and *DROP in the CPY command?

3 Answers  

---

use of PUTOVR,OVRDTA,KEEP keywords?

2 Answers   HCL,

---

1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?

2 Answers   TCS,

---