RE: SQL Triggers and Multiple Member Database Files

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dave Odom
> Sent: Tuesday, April 05, 2005 5:13 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: SQL Triggers and Multiple Member Database Files> 
>
> This is all part of what I've been saying... that the iSeries 
> OS is not
> a true RDBMS.  In real RDBMS's, such as the real DB2s and Oracle, they
> don't support Multiple Member Database files.  If an application is
> based on such an old file architecture(IMS is guilty here as well) the
> Relational standard is to RE-ARCHITECT to Relational form.  That is,
> TABLES, not files, and normalize the multiple members of the legacy
> architecture to however many tables are necessary for proper 
> relational
> architecture.    Then standard SQL will work without all the work
> arounds.   
> 
> The bottom line is, if you want the normal concepts, features and
> functions of standard SQL and DB2 to work as they do in the other true
> RDBMSs, then do as they do;  re-architect your databases and
> applications in DB2/400 like the rest.  
> 
> Take care,
> 
> Dave Odom
> Arizona  
> 


Dave,

First you say "that the iSeries OS is not a true RDBMS."  Then you say "if you 
want the normal concepts, features and functions of standard SQL and DB2 to 
work as they do in the other true RDBMSs, then do as they do;  re-architect 
your databases and applications in DB2/400 like the rest"

If the iSeries wasn't a true RDBMS, then you couldn't implement a RDB and its 
corresponding applications on the iSeries.

I grant you, many legacy DBs on the iSeries don't follow RDB standards.  But 
that doesn't stop the iSeries from being a true RDBMS.  I've said it before, 
it's just as easy to implement a non-RDB and applications on Oracle and SQL 
server is it is on the iSeries.

 


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121