Query in subfile with SFLNXTCHG

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,

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    Or you can chain into any SFL record with a field structured like RRN for the key.
    51,365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following