|
We use SFLCLR and an expanding subfile. If the first page fills up, the user can roll to get another page. When the user is finished keying the text, we can update the DB records for subfile records that are not blank, delete DB records for blank subfile records and add DB records for RRNs in the subfile with no corresponding DB record. Using SFLINZ, you limit the user to the number of records that the subfile was initialized for. And you're right...subfiles are neat! (If only they could be keyed...) --Bruce ---------- From: Tim Truax[SMTP:truax@usaor.net] Sent: Saturday, November 22, 1997 5:46 PM To: midrange-L@midrange.com Subject: SFLINZ (or) SFLCLR Hello all; As a new AS400 person I have a quick question that requires your opinions: On Subfiles (they're very neat!) If I have a file that just contains a Key say.. account number. eg) 12345 and then a sequencing part of the key..say eg) 001 002 003....etc Ergo-- 12345001 Hi Billy here is text line 1 12345002 Here is text line number 2 12345003 thisr line etc.....etc..... If I am updating and adding to this file using an interactive screen job, should I use the SFLINZ and initialize my subfile with blank records then CHAIN back to it and update the blank records with existing text records. (OR) Would you recommend using the SFLCLR and then reading the existing text and WRITING them to the subfile and then WRITING some blank records after your done reading the existing records, to provide the user with some useable keying text lines. Advice appreciated. -- '''''''''''''''''''' :-Tim & Dana Truax-: .................... +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- uucp +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.