[DB2] Problem with select range records

hello again!


In MySQl I can select records from .. to .. using keyword "LIMIT", example:

SQL = SELECT ID, FROM_ADDRESS, TO_ADDRESS, SUBJECT FROM maillog LIMIT 0, 20;
or

SQL = SELECT ID, FROM_ADDRESS, TO_ADDRESS, SUBJECT FROM maillog LIMIT 80, 20;


How I can do this in DB2?

I fount only this command: Feetch first x rows only

Please help me.


--
Pozdrawiam.
Grzesiek; scss (at) poczta.onet.pl

.

Relevant Pages

  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: New "base document" available
    ... That is not normally how command lines are constructed. ... default positional keyword is entered into the keyword name by the function. ... What happens with myprog A,P1=B ... 15 clp-name usage pointer. ...
    (comp.lang.cobol)
  • Re: New "base document" available
    ... COBOL, ... That is not normally how command lines are constructed. ... unless Keyword parameters are being employed. ... 15 clp-name usage pointer. ...
    (comp.lang.cobol)
  • Re: New "base document" available
    ... How to go about retrieving command line parameters? ... the command line arguments (and environment variables) ... Keyword and positional parameters can be mixed in the same command line. ... clp-name points to a string containing "P1" ...
    (comp.lang.cobol)
  • Re: DB2 controlfiles und passwordfiles ?
    ... Welches OS und welche DB2 setzt du denn ein? ... Command Line Processor for DB2 SDK 8.2.0 ... You can issue database manager commands and SQL statements from the ... db2 => connect to sample ...
    (de.comp.datenbanken.misc)