RE: Clearing a subfile

The RRN tells which record of the subfile to write. 1=First record;
2=Second, ...

So in your code, set RRN to zero before your build loop... and increment it
just before each WRITE.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"When a man says he approves of something in principle, it means he hasn't
the slightest intention of putting it into practice."
-- Prince Otto von Bismark

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,

--
Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.