Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Location
    Ottawa, Canada
    Posts
    58

    Unanswered: Last select count

    Is there a function in DB2 to get the count from the last select.

    example...

    db2> select var1,var3,var3,var4 from mytable where var5='test' fetch first 10 rows only;

    db2> function to get last select count without fetch count.


    The reason I'm asking this is that i'm migrating from mysql and they have a function to do this.



    "A SELECT statement may include a LIMIT clause to restrict the number of rows the server returns to the client. In some cases, it is desirable to know how many rows the statement would have returned without the LIMIT, but without running the statement again. To get this row count, include a SQL_CALC_FOUND_ROWS option in the SELECT statement, then invoke FOUND_ROWS() afterward:

    mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name" WHERE id > 100 LIMIT 10;
    mysql> SELECT FOUND_ROWS();

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You did not state which version of DB2 or OS, I will assume you are using 8.1 for LUW.

    There is no function like that as far as I know.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    See if GET DIAGNOSTICS ... ROW_COUNT will help you

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    GET DIAGNOSTICS is only valid in Stored Procedures.

    Andy

Posting Permissions

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