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

How to find d key field of a pf that doesn’t have source physical file?

2 Answers  

---

WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 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,

---

can i use UPDDTA command in rpg program in which contains a file

1 Answers   TCS,

---

How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?

4 Answers   CTS,

---

---

How do you find whether a job is a batch job or interactive?

4 Answers  

---

I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?

6 Answers  

---

how do you use commitment control in rpg?

0 Answers   IBM,

---

I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this

3 Answers   ISG,

---

I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.

2 Answers  

---

how do u track msg in cl pgm???

1 Answers   CTS,

---

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?

3 Answers  

---