× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Mark,

The standard version of Oracle does not allow you to select the
top xx records. You have to buy an add on product (forget the
name) that adds a LOT to the price. On V5R1 you can select
the top records. It is very difficult to provide this functionality in

the standard version of Oracle, MUCH more difficult than doing
the same thing on a pre-V5R1 iSeries. I have done it on both
systems and in Oracle most people would agree that it is ugly.

Oracle does have a built in row id that you can use to refer to
a row. It is a little more flexible than an RRN. Often doesn't do
what you want. With DB2 you can get better functionality with
a UDF, there is one at
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/iseries-toolkit/CVSROOT/src/qrpglesrc/numseq.irp?rev=HEAD&content-type=text/vnd.viewcvs-markup


The place where Oracle beats DB2 is its hierarchical join.
That allows you to things like XML documents very nicely.
DB2 makes up for this in other areas like UDFs, procedures,
and security.

If you are really interested in comparing Oracle to DB2 on the
iSeries, I can get pricing, etc. The standard version of Oracle
seems to be a tease. By the time you buy all of the enterprise
tools and add ons, it is very expensive.

My experience with SQL server is limited, but on the one system
I worked on I was amazed that we had to run cleanup programs
that fixed problems caused when triggers and constraints do
not fire. Microsoft is kind enough to provide a nice utility that
allows you to create these fix programs. If you run the cleanup
often enough, you a unlikely to experience problems. If you
really need to ensure the integrity of your data you have to
verify that integrity when you access the records.

David Morris


>>> mlazarus@ttec.com 02/20/02 06:00PM >>>
Phil,

At 2/20/02 06:03 PM, you wrote:
>Are we missing any database functionality?

  As compared to what?  The rest of the SQL world?  PLENTY!  A couple
of
examples:  How would you retrieve the top 10 of a list?  SQL Server
and
Oracle (I believe) have TOP XX.  How about ROWNUM, which would allow me
to
retrieve, say, rows 50-100?  This is on V4.5, so my apologies to
Rochester
if these have been added in 5.1.

  -mark


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.