RE: embedded SQL Precompiler

["Mangavalli, Ramanujam" <RamM@xxxxxxxxxxx>]

Mark,

I think to retrieve the top XX rows, there are other ways instead of using
TOP XX like in MS SQL server and Oracle. You can always order by the
appropriate columns.

Would the RRN not help for ROWNUM?

just my 2cents.

-----Original Message-----
From: M. Lazarus [mailto:mlazarus@ttec.com]
Sent: Wednesday, February 20, 2002 8:00 PM
To: rpg400-l@midrange.com
Subject: RE: embedded SQL Precompiler


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

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.