SELECT TOP 1 equivalent on AS400

[kh]

I am developing an ASP.Net app which hits an AS400 table. I have the
following SQL statement in ASP but get a token error when I execute:

Select TOP 1 prodmo, prodyr FROM AS400Table WHERE prprty = '11'
AND wlprdc = 'Product'
ORDER BY prodyr DESC, prodmo DESC

What is the SELECT TOP sql equivalent for AS400?

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

 

[Rob T]

There's a lot of SQL commands that are limited when using the odbc
connection/client access. You may want to try and post this in the odbcnet
newgroup. I ran into a lot of these limitations on our interface too.
Checking through my code, I don't see any 'select top' commands....except
where we copied the tables to a SQL server first. ;-)

 

[bruce barker]

in db2 its:

Select prodmo, prodyr
FROM AS400Table
WHERE prprty = '11' AND wlprdc = 'Product'
ORDER BY prodyr DESC, prodmo DESC
Fetch First 1 Row Only


-- bruce (sqlwork.com)


| There's a lot of SQL commands that are limited when using the odbc
| connection/client access. You may want to try and post this in the
odbcnet
| newgroup. I ran into a lot of these limitations on our interface too.
| Checking through my code, I don't see any 'select top' commands....except
| where we copied the tables to a SQL server first. ;-)
|
| | >I am developing an ASP.Net app which hits an AS400 table. I have the
| > following SQL statement in ASP but get a token error when I execute:
| >
| > Select TOP 1 prodmo, prodyr FROM AS400Table WHERE prprty = '11'
| > AND wlprdc = 'Product'
| > ORDER BY prodyr DESC, prodmo DESC
| >
| > What is the SELECT TOP sql equivalent for AS400?
| >
| > *-----------------------*
| > Posted at:
| > www.GroupSrv.com
| > *-----------------------*
|
|