Re: Database design question -- RPG400-L

Subject: Re: Database design question
From: "Rory Hewitt" <roryhewitt@xxxxxxxxx>
Date: Thu, 9 Aug 2007 10:09:45 -0700
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

Tim,

Would it make sense to simply link to a file in the IFS which contains the
notes? You could either have one file per note (horribly complex) or perhaps
a single file per user, with a date/time divider... This might make it
easier for archiving purposes.

Rory

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.

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.