Hi,

I'm using Sybase Adaptive Server Enterprise Edition ( ver 12.5.0.3 ).

I have a big query that fetches about 128,000 records. Our application's JVM is
not good enough ( with default value of 64 M) to hold these many records ( that
are retrieved from the DB ) to overcome this problem I want to break up the
query in such a way that I get first 64,000 records in one shot and next 64,000
( ie from 64001 to 128,000 ) records in the next go so that the JVM can hold the
returing records from the database.

Increasing the size of the JVM decreases the performance of our application
significantly.

The query looks something like this:

SELECT CK.CircuitKey,
CK.CircuitName,
CK.AdminCost,
.......
.......
.......
CK.MLFRAutoErrorDetection,
CK.MLFRErrorRetryCount
FROM VCircuit VC, Circuit CK
WHERE ( VC.CircuitKey = CK.CircuitKey) AND CK.ClearCallatDest!=0x00000001
AND
( VC.CardKey1 = 0x002d864a OR VC.CardKey2 = 0x002d864a
OR VC.CardKey3 = 0x002d864a OR VC.RedundantCardKey1 = 0x002d864a
OR VC.RedundantCardKey2 = 0x002d864a ) ORDER BY CK.CircuitName


Any suggestions how I can achieve this ??

Thx in advance,
Best Regards,
Amit Gupta

Amit Gupta <amitgupta (AT) lucent (DOT) com> wrote


http://www.isug.com/Sybase_FAQ/ASE/s....2.html#6.2.12

-bret

hi,

You can do it by declarin a cursor as

declare <cursor_name> cursor
for select * from <table_name>


open <cursor_name>

set cursor rows 64000 for <cursor_name>

fetch <cursor_name>

This time it will fetch 64000 records

again

fetch <cursor_name>

This time,it fetches from 64000 to 12800 records

-- Jerrie