Can anybody tell me the setps to create .csv file in IFS
folder on AS/400.
I also need to know how I can send this .csv file to PC in
xls sheet.....?
Answer Posted / remya
1. CPYTOIMPF FROMFILE(database-file) TOSTMF(PATH/file.csv)
This command will copy the database file in .csv format.
2. ftp the csv file & open it with MS EXCEL...
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
how do you use commitment control in rpg?
How to declare the pull button in AS/400..
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
can you debug ile rpg program using isdb?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
what do you mean by an input subfile, what are the keywords required?
How can we override a file during runtime in rpg?
What are the types of identifiers?
What is the difference between iter and do?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
What is ment by record level identifier?
what is program status data structure?