Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9560 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 |
we hav job which is running as batch. it takes atleast 06hours to complete tht job. bu i wana do tht job with in 3hours.........? so plz post ur answers
A rpg or clp command to find if the file field is defined as a character or numeric field.
wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.
while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue
What is the difference between inner join @ outer join
How to select highest score of each subject or how to select highest income of every month?
If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?
In ProgramB there is a SBMJOB, which is a call to program C .There is also a CALL to program D from B. How would you check the program C has been executed in D?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
RPG400 
