Re: Database design question

Francis,

Exactly what is the limitation to how much data can be in a TEXT field on
a html form? Just curious as to how big a field could be until it fills
up the browser screen.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Francis Lapeyre" <flapeyre@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/09/2007 10:36 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: Database design question






Or you can create a file that has a key by user, date, time, and a
sequence
number. The text field itself would be 75 or so bytes (which will fit onto
the entry screen as a subfile). If you have merely a 3-byte sequence
number,
you can fit 74,925 bytes of notes for each user/timestamp (enough for a
fair-sized short story). Plus, it conserved disk space over large fixed
length.

Maybe, as Rob said, make them varying in length (big enough to fill most
of
a screen), and have the sequence number; that way, if one screen isn't
enough, you can have it all under the same user and timestamp.


On 8/9/07, Matt.Haas@xxxxxxxxxxx <Matt.Haas@xxxxxxxxxxx> wrote:

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.

--
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.


--
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.

--
Francis Lapeyre

Solum potestis prohibere ignes silvarum.
--
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.


--
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.