Position to Specific Records in AS/400 Subfile

2475 pts.
Tags:
AS/400
AS/400 Subfiles
Hi! For example when we display the records in a subfile normally it is listing out all the records from the first record of a physical file. In the same, I want to show all the records in a subfile but when they view it, it should show the page related to the current month or date. In my physical file I have many fields including month & year (For ex: 05/2014) when I display the subfile its always showing from the beginning of the file (For ex: 01/1999). Simply I just want to direct the view to the current month always. Then if the users wanna see previous records they can use PageUp or another function keys. Please help to find out in both single page and record at once. Surey.

Answer Wiki

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

Two ideas come to mind.
1. Give them an option to “Position to: a specific date. I generally do that on any SFL that has more than 100 records.
2. As you are filling the SFL, check the date on the records you are writing and when you get to the date you want, put the SLF record number in the field you have assigned as SFLRCDNBR

Discuss This Question: 1  Reply

 
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
  • philpl1jb

    In your record definition, add the SFRCDNBR keyword

       SFLRCD     4S 0H   SFLRCDNBR(*TOP)

    As you load the subfile in your program, set the value of SFLRCD to the RRN of the first row you want to display. 

    SFLRCD must have a value within the range of the rrn's of the subfile.

    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