Hi,
Just an other comment:
The relational database (DB2 UDB for System i) integrated in the operating
system (QS/400, i5/OS) is the only relational database that covers the SQL
standard (SQL-2003) for 100%!
The SQL standard describes how a relational database must be defined and
which features must be covered. As others already pointed out, even if you
do not use all features they are available and you are working with a
relational database.
Oracle for example covers the SQL standard only for around 70-80%. All other
databases are much more behind.
But a lot of people think we cannot have a "real" database, because we have
no DBA (Database Administrators) and we have not all the troubles that exist
with other databases for examples: 1. Because our database is integrated in
the operating system and due to the fact of the single storage management,
you do not have to create and manage tables spaces or buffers, that means
you do not have to determine where on the disks your files must be stored,
how much disk space must be reserved or which block length would be the best
for your table. If your physical file reaches the maximum of allowed rows,
you simply enhance it (or set it to *NOMAX). 2. You do not have to
reorganize any logical file or SQL indexe, because the access paths get
always out-balanced.
Physical files or SQL tables may be reorganized to physically remove the
deleted rows, but a simple RGZPFM is enough. 3. You do not have to run
statistics manually, because there is a never ending job, that permanently
collects the statistic information. ... And so on
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown) "If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Roger Harman
Gesendet: Thursday, May 17, 2007 00:52
An: midrange-l@xxxxxxxxxxxx
Betreff: Re: Definition of a Relational Data Base
I had to laugh a few years ago when I was told that MS-SQL Server was
introducing some great new features - like row level locking. Gee, we've
only had that since day one of the S/38. The AS/400 (that was the name at
the time) people in the room just laughed. But it got better when the
announcement went on to say that "ALL" you needed to do to take advantage
was to unload and reload the entire database. Then, we looked like the
laughing boardroom IBM commercials.....
http://www-03.ibm.com/servers/eserver/iseries/resources/videos_ads.html
See: Laughing Boardroom: Automatic
dilbernator@xxxxxxxxx 05/16/2007 3:22:56 PM >>>
Michael,
You can use SQL to create, maintain, and delete the tables. I believe that
counts as a DDL. You can write trigger programs in SQL, RPG, COBOL, CL and
a few other languages I can't think of now. Constraints are there if you
want to use them. It is not the same database as it was 25 years ago.
It,
like the PC and the AS400/iSeries/i5, they have all evolved. V5R4 has
more
functionality in SQL than V5R3 did.
midrange.com
