Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    22

    Unanswered: set rowcount question

    I'm developing a Java application that connects to the Sybase database using jconnect JDBC driver.

    I want to limit the number of rows returned from a query, so I set the rowcount appropriately:

    stmt.execute("set rowcount 5");


    It seems that this setting remains in effect for the active session.

    How can I turn this setting off after the SQL statement I'm interested in?

    thanks in advance
    - Garry

  2. #2
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: set rowcount question

    stmt.execute("set rowcount 0");

    This should clear the set rowcount value previously defined.

Posting Permissions

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