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

Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  

---

There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented

3 Answers   Cap Gemini, IBM,

---

How do you find out whether a record is present in the physical file without reading the file? for Example Employee No: 100 in an Employee master.How do we find out whther 100 is present in Employee master without reading the file?

11 Answers   Bank Of America, CSC, IBM,

---

Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?

2 Answers   Cap Gemini,

---

i would like to know under what circumstance the object will get locked on AS400.

5 Answers   IBM,

---

what is file identifier wher we can use

1 Answers   IBM,

---

in a cl pgm records are copied to a file in qtemp a pgm is called to delete records from the file in qtemp no of records in file in library qtemp is checked wat shud be the count of records let say it was 10 initially endpgm

2 Answers  

---

In single page subfile,if I select the mutiple options in 1 page and without pressing enter,I press rollup key (pagedown).In such case how I can handle it in rpg becasue in single page we have to handle it in pgm. It would be helpful if any one answer with coding

4 Answers   Infinite Computer Solutions,

---

do you use message subfiles? What are the necessary keywords required coding a message subfile?

0 Answers   IBM,

---

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 Answers  

---

How can we receive values from a called procedure in CL?

1 Answers   IBM, NTT Data,

---

Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?

1 Answers  

---