Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17

    Question Unanswered: Informix return more than 100 rows throug a view

    Hi,
    I have view which collect data from diffrients tables, and all these columns which is in this view are indexed at the orginal tables, my problem is when I run this view and this view return about 5000 rows, I cunt get all these rows at the same time, it return about 100 rows then the view take a break and then return more 100 and agien a break and then gives 100 rows. My quetion is dos any body know how get more than 100 rows at time ?

    Thanks in advance
    Linux

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please, run select from view into temp xxx with no log, then select from temp table.

    Gustavo.

Posting Permissions

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