[ffert]

Hi,

I'm creating a software, and I have a dilemn... To check it I use MySQL, but I want my software to use a lot of kind of différent DB (oracle, DB2, informix, etc...)

But I have to know :

Does Adabas support something like that (and if not how to do it) :

SELECT fields FROM Table LIMIT 0,500

????

thank you very much for a quick answer, because All development depend of the answer !!!

thank you,
bye.

[benboa]

hi, have the same problem has u !
i've seen in the referencial of adabas, that it contains the predicate : rownum

<rownum predicate>
Function
limits the number of rows of a result table.
Format
<rownum predicate> ::=
ROWNUM < <rownum spec>
| ROWNUM <= <rownum spec>
<rownum spec> ::=
<unsigned integer>
| <parameter spec>

But it don't work :
---> odbc_errormsg :
[SOFTWARE AG][ODBCLIB A][ADABAS]Column not found;-4005 UNKNOWN COLUMN NAME:ROWNUM.

does anyone has already use it ?
Please help

[ffert]

Perhaps we have to write something like this :

SELECT * FROM table WHERE (ROWNUM > 500) and (ROWNUM < 1000)

I haven't test it yet.. but.. it is perhaps the right solution...

Thanks bye..