Query in subfile with SFLNXTCHG

RamvishakRamesh

2505 pts.

Tags:

AS/400

AS/400 Subfiles

I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing anything on to the subfile, the Readc is not reading any records when an enter is pressed. Please advice,

Asked: February 23, 2013 4:34 AM Last updated: February 25, 2013 1:41 PM

Answer Wiki

Last updated: February 25, 2013 1:41 PM GMT

Michael Tidmarsh62,160 pts.
History
Contributors
- Ordered by most recent
- Michael Tidmarsh62,160 pts.
- SemiTechieGeo70 pts.

Thanks. We'll let you know when a new response is added.

Your subfile record probably has (or should have) a SFLNXTCHG keyword conditioned by one or more indicators.

Set the indicators so the SFLNXTCHG condition is TRUE when you write or update each subfile record that you want the READC to read.

Discuss This Question: 2 Replies

TomLiotta Feb 23, 2013 5:44 AM GMT

When you write a blank subfile record (or write any subfile record), you can write it with the SFLNXTCHG (Subfile Next Changed) attribute enabled. That will cause that record to be read by the next get-next-changed operation even if the user did not make a change. It would have to always be on for every blank record if I understand correctly, so it seems a little pointless. You might as well just use a straight READ and skip testing for changes. -- Tom

125,585 pointsBadges:

report
philpl1jb Feb 23, 2013 2:00 PM GMT

Or you can chain into any SFL record with a field structured like RRN for the key.

54,090 pointsBadges:

report