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.....?
- 2 Answers
- 8833 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / daithuan
I am quite sure you can use the WRLNK command to access IFS folder and then from there copy/create/send files to and from as400/I Series.
| Is This Answer Correct ? | 0 Yes | 1 No |
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.
Delete FileName at first statement in RPG.
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
When it is desirable to describe files Internally?
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
3 members in databasefile .how to read records from all the members??
what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????
What is the purpose of record level identifier?
What is I90(Insure 90)?
what is commitment control?explain about it?
RPG400 
