My understanding is that in ARS 7.5, an extra "top xxx" is added to the SQL 
statement in sql server databases and a extra " .... AND ROWNUM < xxxx " is 
added to Oracle ones.
I can't remember what is the syntax for DB2

So for instance in Oracle

SELECT C1.T500, C2.T500 FROM T500  where C2 = 'Demo'

would become

SELECT C1.T500, C2.T500 FROM T500  where C2 = 'Demo' AND ROWNUM < 10000

Guillaume

________________________________
From: Action Request System discussion list(ARSList) [[email protected]] on 
behalf of Kali Obsum [[email protected]]
Sent: Thursday, April 22, 2010 6:16 AM
To: [email protected]
Subject: Search Results Returned Limit

**
In the Remedy User Tool, there is an option to limit the number of search 
results to be returned.

How does this work in the DB level? Does it mean that if the query performed 
produces 10,000 results, the DB will still search for those 10,000 but only a 
limited number will get displayed in the User Tool? Or will the limit already 
be incorporated in the query such that only the top N results will be queried?

Regards,
Kali


NOTICE

The information contained in this email is confidential. If you are not the 
intended recipient, you must not disclose or use the information in this email 
in any way. If you received it in error, please tell us immediately by return 
email and delete the document. We do not guarantee the integrity of any e-mails 
or attached files and are not responsible for any changes made to them by any 
other person.



_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Reply via email to