Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    France
    Posts
    10

    Question Unanswered: Does Adabas support LIMIT

    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.
    DataBase, Delphi, php, Yes, I like....

  2. #2
    Join Date
    Jul 2004
    Posts
    1

    It seems that Adabas have RowNum

    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

  3. #3
    Join Date
    Mar 2004
    Location
    France
    Posts
    10

    How to use RowNUM

    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..
    DataBase, Delphi, php, Yes, I like....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •