RE: Database design question

[<Matt.Haas@xxxxxxxxxxx>]

Tim,

A lot depends on what's going to read and write the data. On the
surface, this sounds like a good use for a CLOB (or large variable
length fields) to store the notes but if RPG/400 programs are going to
use the data, you can't use them (CLOBs) and large fixed length fields
would be better.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of tim
Sent: Thursday, August 09, 2007 9:57 AM
To: Rpg Forumn
Subject: Database design question

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.