RE: SFLINZ (or) SFLCLR

["Kahn, David (kahn)" <KAHN@xxxxxxxxxxxxxxxxxx>]

Tim,

You could successfully use either technique. I would probably use the
SFLCLR followed by writes one screen at a time. When you run out of
database records just keep throwing out blank lines in response to Page
Down (Roll Up).

Also consider having the sequence numbers and an extra copy of the text
as hidden fields. That way you should be able to keep your database
updates restricted to new or genuinely changed (not just over-keyed)
lines. 

A common source of problems in this kind of routine is blank lines
within the text body, so you will want to consider carefully how you are
going to handle them. E.g. how will you handle it if you start with 3
text lines and the user tabs down to line 7 and keys some new stuff? It
would be nice if your software could handle having records 4, 5 and 6
absent from the data base, but still respect the line spacing.

It would also be nice to allow the user to insert, move, copy and delete
lines if you can handle that too.

Dave Kahn, TCO, Kazakstan
=========

kahn@tengizchevroil.com   (to November 25)
dkahn@cix.compulink.co.uk (from November 26)


>-----Original Message-----
>From:  Tim Truax [SMTP:truax@usaor.net]
>Sent:  Sunday, 23 November, 1997 04:47
>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
+---