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
what is a rpg?
How Chain operation copies the record's data to the input buffer for the program?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
what is the rpg system?
how do I declare a minor?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
is this a rpg channel?
When it is desirable to describe files Internally?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
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?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
How to write record if no field or the field are different in physical file in rpgle ?