Re: Clearing a subfile

Pete,
This is what I use to clear a subfile....
sfldsp = *off;
sfldspctl = *off;
sflclr = *on;
write ctl1;
sflend = *off;
mrrrn = 0;
rrn = 1;
sfldspctl = *on;
sflclr = *off;

For me though....
sfldsp, sfldspctl, sflclr, sflend are all their own indicators. Since
your post I see that I could have set up sfldspctl and sflclr on the same
indicator but have one as the NOT.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



Pete Helgren <pete@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/20/2010 07:35 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
RPG Midrange Discussion <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Clearing a subfile






I am updating a set of records using SQL and when I am done, I want to
reload the subfile records so the user can see what records have not yet
been processed. The code I saw an example of did it like so:

Set the relative record number for the subfile to zero;
set ON the indicator for SFLCLR (which also sets OFF SFLDSPCTL)
issue a write to the Subfile control record format
set OFF the indicator for SFLCLR (which sets ON the indicator for
SFLDSPCTL)
load the subfile with records

When I do that I get the following:

Incorrect record number in subfile SFLRCDNBR or SFLSIZ field.

It complains about the record number being zero so I set it to 1 and
then tried again. This time it issues a duplicate key error.

So, how do I clear the subfile of all records so I can reload it?

Thanks,