RE: Logical File or OPNQRYF or any other way ? -Legacy iSeriesFlatFiles

So the fact that the foreign keys and primary keys are not known to the
database itself, only to the individual data stores, is a matter of
implementation? I see...so if I have a file with a primary key, that
fact isn't known to other files. Of course, it is known to the OS. And
if I have a file that has a foreign key from some other file, if it's
set up with referential integrity it's relational, and if not it's not?

> -------- Original Message --------
> Subject: RE: Logical File or OPNQRYF or any other way
> ?     -Legacy iSeriesFlatFiles
> From: "Wilt, Charles" <CWilt@xxxxxxxxxxxx>
> Date: Tue, March 08, 2005 9:53 am
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> > michael@xxxxxxxxxxxxxxxxxx
> > Sent: Tuesday, March 08, 2005 9:30 AM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: Logical File or OPNQRYF or any other way ? -Legacy
> > iSeriesFlatFiles
> > 
> > 
> > So the iSeries database consists of 1 to many data stores that can be
> > manipulated using relational constructs, but since the keys (primary
> > and foreign) are not known to a governing entity, the iSeries database
> > can't be identified as a RDBMS. Is that a fair statement?
> > 
> 
> No the iSeries DBMS is an RDBMS.
> 
> It's just most databases implimented on it are not RDBs given the current 
> meaning of the term.
> 
> You need to differenciate between the OS/RDBMS and the application/DBs runing 
> on it.
> 
> Note that you could define a DB without relationships in Oracle or SQL server 
> as easy as you can in DB2 for iSeries.  You just don't see that as often.
> 
> 
> Charles
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.