Hi, I've seen something similar before on BRIO. Sounds like you're using a
query tool like BO or suchlike?
Have a look around the tool's configuration and settings menu for anything
that sets an array fetchsize, cursor block size or similar, and play with
those. Unfortunately the name will vary from product to product. On Brio
Explorer, from memory, it was called 'Large Buffer Query Mode'.
You could also review your client and server side CLI settings, if you're
using CLI.
Regards
Alex Levy

-----Original Message-----
From: Reimer Bill
[mailto:db2udbdba-ezmlmshield-x16809395.[Email address protected]
Sent: 10 April 2008 18:44
To: LazyDBA Discussion
Subject: max number of records returned.


I am using IBM's SQL08015. There seems to be a limitation as to the number
of rows that are returned to the screen. Above a certain limit (have not
determined the exact number) the data gets returned and stored on my PC, but
does not return to the application screen. The file is stored in D:\Program
Files\IBM\SQLLIB\DB2. Anyone know of how to get around this limitation?

Greatly appreciate your assistance.



********************
NOTICE OF CONFIDENTIALITY
This communication including any information transmitted with it is
intended only for the use of the addressees and is confidential.
If you are not an intended recipient or responsible for delivering
the message to an intended recipient, any review, disclosure,
conversion to hard copy, dissemination, reproduction or other use
of any part of this communication is strictly prohibited, as is the
taking or omitting of any action in reliance upon this communication.
If you receive this communication in error or without authorization
please notify us immediately by return e-mail or otherwise and
permanently delete the entire communication from any computer,
disk drive, or other storage medium.

If the above disclaimer is not properly readable, it can be found at
www.td.com/legal

AVERTISSEMENT DE CONFIDENTIALITE
Ce courriel, ainsi que tout renseignement ci-inclus, destiné uniquement
aux destinataires susmentionnés, est confidentiel. Si vous
n’êtes pas le destinataire prévu ou un agent responsable de la
livraison de ce courriel, tout examen, divulgation, copie, impression,
reproduction, distribution, ou autre utilisation d’une partie de ce
courriel est strictement interdit de même que toute intervention ou
abstraction à cet égard. Si vous avez reçu ce message par erreur ou
sans autorisation, veuillez en aviser immédiatement l’expéditeur par
retour de courriel ou par un autre moyen et supprimer immédiatement
cette communication entière de tout système électronique.

Si l'avis de non-responsabilité ci-dessus n'est pas lisible, vous
pouvez le consulter à www.td.com/francais/legale


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page