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 |
wat is meant by hidden field , why it is used?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
how can I tell when to replace the array?
I am Submitting one job in batch that job calls three progams(PGMA, PGMB, PGMC). PGMB should be called after sucessfully completion of PGMA as like for PGMC also. So Can you please tell me how can we do that (without using data area)
Can you copy the records created by the OPNQRYF to other files and how?
What is the purpose of Panel Groups?
1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?
How can we make use of SETLL operation in CL?
RPG/400 number of Records present in a physical file using file information data structure FPF001 IP E DISK F KINFDS INFDS1 IINFDS1 DS I *RECORD RECORD Is this coding correct sir,i have given I P E that is I- input,P-primary file,E-externally described. Primary to use RPG logic cycle,is this the correct method because we have to find number of records present using file information data structure in RPG/400 without doing any input/output operations on the file and also without using DSPFD,SQL. If the above coding is correct means,when i compile the program it gets compiled,but if i call the program it does not return anything,i need number of records,please complete the coding sir.
Can AnyOne tell me how to read join logical file in rpg from starting to end?
this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002
To check the locks , we use cmd WRKOBJLCK , but how we confirm whether it's objeck lock / member lock. I confused with the Lock type and Status values...Can any body please tell me ...