Setps to create .csv file on IFS folder in AS/400(
V4R3)....?

Answers were Sorted based on User's Feedback



Setps to create .csv file on IFS folder in AS/400( V4R3)....?..

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(',')

Is This Answer Correct ?    2 Yes 0 No

Setps to create .csv file on IFS folder in AS/400( V4R3)....?..

Answer / samul

Reshma,

Thanks for info.

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

Thanks ,
Samul

Is This Answer Correct ?    0 Yes 1 No

Setps to create .csv file on IFS folder in AS/400( V4R3)....?..

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

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More RPG400 Interview Questions

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 to change the length of the field in a physicalfile?

12 Answers  


how do I play {insert rpg system here}?

0 Answers   IBM,


suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis

1 Answers  


1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword

1 Answers   CSC, CTS,






what are the key words you must use when using a subfile?

0 Answers   IBM,


Can any one plz explain the concept of INFSR, *PSSR, INFDS AND PSDS, I' confusing about PSDS and *PSSR, Wat is the difference btw them, wat PSDS will do????

1 Answers  


what is the difference between the procedure and module in ILERPG?

4 Answers  


what is EXCEPT command in rpg and use

1 Answers   Active Brains,


how can I tell when to replace the array?

0 Answers   IBM,


How to read a record from file where there is multiple record occurrence is available?

1 Answers  


How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)

6 Answers   CTS, IBM,


Categories