3 members in a databasefile .how to read records from all
the members?????????
Answers were Sorted based on User's Feedback
Answer / samul
OVRDBF FILE(TEST)
TOFILE(*LIBL/TEST)
MBR(*ALL)
before calling pgm,execute above cmd.
cheers...
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / reena
there are 2 ways.
1. using OVRDBF
2. By creating and LF.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi kumar
1. Through RPG, using EXTMBR(*All)
2. Through CL, OVRDBF FILE(TEST) TOFILE(*LIBL/TEST)MBR(*ALL)
Is This Answer Correct ? | 2 Yes | 0 No |
1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?
What you have to do in the display file when you are using message subfile?
i would like to know under what circumstance the object will get locked on AS400.
is this a rpg channel?
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
I am reading a file in CL program. and MONMSG CPF0864 has arrived means EOF has arrived. Now i want to read this file again. How i can do this?
5 Answers CitiGroup, Symphony,
What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
1.The questions have given an array declaration and move operation then this statement is correct or not?
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.....?