Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: limit rows using informix standard edition 7.2

    I tried using cursors in stored procedure, I guess ISE does not support
    dynamic queries/cursors in stored procedure. ISE does not support 'SKIP 5 FIRST 5'

    we have thousands of records in our database.
    I need to be able to bring first 100 and then the next hundred records, and so on using java..

    Please someone suggest me how to do this in an easy and efficient way using
    java?? Any suggestion is highly appreciated..

  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    I don't know if Informix SE support the WITH RESUME option on the STORED PROCEDURE and how java will behave with this option...maybe can help you.

    Google Translate
    WITH RESUME Keyword
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

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