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)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program
i want to perform uniqness on db file bt my db file nt hving key by useing rpgle.
What are different ways to pass data between programs and which one is the efficient way?
1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF
Can a indexed file be accessed in arrival sequence in RPG?
what are the key words you must use when using a subfile?
What is the difference between copybooks and subprocedures in as400?
What is the syntax of passing parameters to a procedure by value?
how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
How many program bind in one module....
How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.
Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?