Re: Database design question

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.