Setps to create .csv file on IFS folder in AS/400(
V4R3)....?
Answers were Sorted based on User's Feedback
Answer / justin lopes
Use the command as follows on Physical file
CPYTOIMPF FROMFILE(LIBRARY/FILENAME) TOSTMF('/QDLS/TEMP/TEST.CSV') +
MBROPT(*REPLACE) FROMCCSID(37) +
STMFCCSID(*PCASCII) RCDDLM(*CRLF) FLDDLM(',')
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / samul
Reshma,
Thanks for info.
Can u plz eloberate this wiht exapmle ,it will be helpful
for me.
Thanks ,
Samul
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / reshma
Hello
To create a .csv file
u need to use command cpytoimpf on the file.
If u want it copy to a folder then
CPYTOPCD with .CSV extension
Thanks
Reshma
| Is This Answer Correct ? | 0 Yes | 8 No |
Hi, Can anybody give me real sinario for SFLRCDNBR?with example?
suppose there are 100 records and i want to read records between 60-70 how we can read this 10 records in rpg
what was the robotech rpg?
How can i check the object existance in RPG program without using QCMDEXC command.
what r drawbacks of OPM? Why do we go for ILE RPG?
where we give the MSGSFL in rpg400?
1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?
HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?
The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?
How can you determine the number of characters in a variable?
How to sort an array in descending in RPG
There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented