Re: Database design question

["Gene Burns" <burns.gene@xxxxxxxxx>]

I currently have an application that does exactly that, with the entry being
done through a green-screen application.

The file is defined as follows:

Key    Field            Text                              Type  Length
> From   To
K01 CMYR7C     Claim Year                          S     4,0         1
4
K02 CMYC7C     Claim Year Count                 S     4,0         5      8
K04 EDAT7C      Date Entered                        L    10           9
18
K05 ETIM7C       Time Entered                        T      8         19
26
       ENBY7C     Entered By                           A    10         27
36
K03 NTYP7C      Note Type                            A      1         37
37
       NOTE7C      Note Text                            A  3002        38
3039

Gene

On 8/9/07, tim <tim2006@xxxxxxxxxxx> wrote:
> Hello all,
>
>
>
> I have to design a database that will hold notes keyed by a user. These
> notes can be anywhere from a few words to a several hundred. Notes will be
> tracked by user/date/time. There can be hundreds of separate notes entered
> each day, so this database will get rather large.
>
>
>
> As far as defining the actual field that will hold the note. I would like
> some design feedback. Should it be fixed, variable, other.
>
>
>
> Thanks for all the input in advance.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.