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.....?
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 |
I have a PF(ABC)with no key fields. PF(ABC)have 2 fields (cusno and cusname). Please let me know how can i read the cusno = 1150 directly from PF in CL and RPG program(Without creating the LF and without reading the complete file and then compare 1150)
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?
1.Write code to read the records from a file and load an array of size 99? Make sure that you take care of all the error conditions?
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?
Hi guys. Im in AS/400(RPGLE,CLP) from last 1 year.Now i wan to upgrade my Knowledge in AS/400. Suggest me some new fields & courses which falls under AS/400. Waiting for your quick Response.
suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis
How can we override a file during runtime in RPG? Without using OVRDBF or calling a CL program
what is EXCEPT command in rpg and use
What are the necessary keywords required to code a message subfile?
is this a rpg channel?