Interested to Buy Any Domain ? << Click Here >> for more details...
i want to display the 10000 record in a subfile by using
loadall , can we do it?
- 10 Answers
- 34347 Views
- CybAge, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mithun paul
We can't display the 10000 records in a subfile by using
load-all. Because, in the case of load-all subfile, system
take care the Page-Up and Page-Down request for up to 9999
records.But byond 9999 records system can't take care the
Page-Up and Page-down request and program crases.
In this case we have to use single page subfile, where we
have to write code for Page-up and Page-down and it will
process any number of records.
Mithun Paul
KMG Infotech
Kolkata
| Is This Answer Correct ? | 44 Yes | 1 No |
Answer / reshma
No
We Cant load 10000 records through Loadall Subfile
for that we 'll have to use Single page subfile.
Regards
Reshma
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / kalyan
can i clear the 9999 records and add another 9999 records
into subfile(load all)?
is it possible in Load all?
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / amit
KALYAN , YES YOU CAN DO IT UNLIMITED TIME THIS BUT THERE IS
A CONDITION THAT AT A TIME YOU ONLY CAN LOAD 9999 RECORDS
IN A LOAD ALL SUB FILE.COZ RRN 'S SIZE IS 4,0( RRN-RELATIVE
RECORD NUMBER) WHICH CAN CONTAIN AT MAX UPTO 9999. FOR
LOAD ALL SUBFILE YOU CAN CLERE ANY TIME AND CAN LOAD NEXT
9999RECORDS INTO .FOR THIS YOU HAVE TO SET RRRN 9999 TO
RRN - 1 FROM THIS POINT YOU WILL START AGAIN LOADING.
cheers
Amit
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / jitender chandel
Hi
First thing is that u can’t load more than 9999 at a time at
all.
and this is the limitation in Load all subfile
If yout pf contain mote than 9999 records and you want to
display all the records in load all subfile then you have to
do some changes in your load subroutine of your rpg pgm.
In the load subroutine
if RRN > 9999 then it make rrn = 1 then it again load the
subfile
Jitender Chandel
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vivek dwivedi
Hi,
This is not possible. Reason is that --> Load all subfile load the records of the file to subfile buffer at compile time. So in this can not clear the subfile buffer at all.
You can do in Expanding subfile. Because Expanding subfile loading the record to buffer as per sflsize and page down handle by programmer so that programmer can clrsfl .
Hope you understand.
Thanks
Vivek
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravikumar
Yes.. It is possible.
With the help of sflclr keyword..
When 9999 records loaded in subfile buffer and displayed .. After displaing , with the help of sflclr keyword 1st clear the subfile buffer and load with the remaining records from databasefile with 10000th record and display with sfldsp keyword in loadall subfile...
I hope this answer will helps u.. Thank you
I have faced this question in ibm...
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / ravi
The moment the PF exceeds 9999 records and you try to display the subfile it fails with session/device error occured.
But, in expandable/self extending, you can page down till 9999 and the moment RRN is sfl becomes 9999 and you try to write the 10000 record, it fails because the records are stored in buffer and rrn accumulates.
single page/page by page, no storage in buffer, we have to do pgup/pgdwn.
| Is This Answer Correct ? | 0 Yes | 2 No |
in conjunction with which statements can orxx and andxx conditions be used ?
what is scan and xlate?
define what a data area is along with a brief example of what it may be used for?
When will DUMP and DEBUG opcodes be ignored?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
how do you read changed records backward in subfile?
what does dfu program you to do on a record?
When does the DFT keyword in PF be used?
how do you use commitment control in rpg program ?
In Which Specs Arrays, Tables & Constants Are Defined?
How can we sort an array?
1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code?
RPG400 
