Re: Database design question -- RPG400-L

Subject: Re: Database design question
From: Nathan Andelin <nandelin@xxxxxxxxx>
Date: Thu, 9 Aug 2007 13:29:42 -0700 (PDT)
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>

James L. wrote:
The only problem with LOB fields is that they are invisible
to the native/RPG Data Management runtime, which means
that you are locked into SQL and only SQL for accessing
those fields.

One might also reason that NOTES are different than DOCUMENTS and that notes don't need the storage or processing requirements of documents, but I'm still mulling over Walden's point about having one program handling notes for users, items, work requests, screen help text ... why not make it generic?

____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7

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.