How to fetch all records from a table through SQLExplorer

Posted by pichaiyamoorthy on 07-Feb-2012 09:18

Hi,

I am running SELECT query through SQLEXP and trying to export results into a file but some reasons I am not able to get more than 101 rows. Is there any limitation on this? Can you help me how to export all rows?

I face the same issue even when I tried to do it manually on SQL explorer but this is the message but i don't want this prompt sometimes,

"Fetch next 101 records (y/n)? n"

Thanks,

Pichaiya

All Replies

Posted by Admin on 07-Feb-2012 09:51

Window -> Preferences and then

Progress DB Navigator -> SQL Results rows to batch

Posted by pichaiyamoorthy on 07-Feb-2012 10:15

Hi,

I am connected to my server through PUTTY. How/where to change this preference?

Thanks for your reply.

Posted by Admin on 07-Feb-2012 10:21

I am connected to my server through PUTTY. How/where to change this preference?

 

Sorry, I did misread your post - I was assuming you were using OpenEdge Architect/Progress Developer Studio.

Posted by Rob Fitzpatrick on 07-Feb-2012 17:04

You should see a file called SQLExplorer.properties in the directory where you run sqlexp.  It should have a line that says "FetchLimit=101", or something similar.  You could change that, or specify "@FetchLimit n" where "n" is your desired number.

But first have a look at Knowledge Base article P26439 for more info, and possible constraints.

Posted by pichaiyamoorthy on 09-Feb-2012 13:31

This change works fine but I can pull up to 30000 records only. Its defaulting to 101 if I change fetchlimit more than 30K.

Thank you very much for your help.

This thread is closed