3 members in databasefile .how to read records from all the
members??
Answers were Sorted based on User's Feedback
Answer / guru
Reading all the members in a pf cannot be achieved in a
single override command and which is cumbersome too. So
rather using override, you can use EXTMBR('*ALL') in the
file specification in your rpgle program. So when you read a
file, it will automatically read all the members records
from your data base file. This is FYI
Regards
Guru
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / swadesh
With the OVRDBF command give the member name as *all.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ravi shankar porwal
U can also read the records of all members using logical
file.create logical file based on given PF(have more than
one member) and read it using rpgle program.
| Is This Answer Correct ? | 2 Yes | 2 No |
HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
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.
we are sending data of physical file to screen design and it is showing no record why?
How to print output from openquery in as400 ?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
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?
How to index LF by relative record no (RRN)
HI, 1: WHAT IS THE FUNCTION OF %KDS?WITH PROGRAMMING CODES EXAMPLE 2: WHAT IS THE FUNCTION OF Z-ADD AND Z-SUB ? WITH PROGRAMMING CODES EXAMPLE
how do I preserve and clean the array?
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?
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