1. I don't think there is a way to make it load all results in to the window.
2. I use a separate results window which has that menu option and the same row limits. Using separate windows is really not that more effort. I can do quick result comparisons and I can dismiss the window by pressing ESC. One extra step that is required but is annoying is that if you are keyboard oriented getting the grid to "activate" for your cusor actions you have to first tab into the grid area.
-Matt
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Monday, January 15, 2018 3:37 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: iACS-more data available
Justin & Matt
As to #1, I don't know a way on the display to show more than in increments of, it seems, 100 - something for an RFE, perhaps, to configure this.
There are options for the JDBC connection help with optimization, like *FIRSTIO and *ALLIO - I think this, being basically a batch process, the default would be *ALLIO - that's an educated guess, BTW.
For #2 - you can save the results - you need first to go up to the Options menu, the "Enable save results" option - I have it set to always. If set to never, your option to save is grayed out, as I recall.
That option to save is when you right-click anywhere in the results window - and you can select the file type and location. I never do any selection when I do this, it then gets all the data into the PC file - it might take only the selected rows if you have a selection - I just don't remember.
I don't see "Save results" on the file menu - the saves there are for the SQL statements themselves, not the results, so far as I can tell.
Very cool tool - I use it all the time.
Right-click is your friend - but who would have thought you needed to be in the results? I'm just a happy right-clicker, I guess.
Oh - there is under options an item to show results in separate window - not sure if that has the same 100-row increment.
Regards
Vern
On 1/15/2018 3:27 PM, Tyler, Matt wrote:
1. Yes, but for me it requires using Ctrl+End many times, if you want the entire list within the results window.
2. Yes, it's under the File menu, Save Results (available for quite some time but I am at 1.1.7.2).
-Matt
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Taylor
Sent: Monday, January 15, 2018 2:22 PM
To: MIDRANGE-L (midrange-l@xxxxxxxxxxxx) <midrange-l@xxxxxxxxxxxx>
Subject: iACS-more data available
Two questions regarding iACS Run SQL Scripts:
1. I get this note at the bottom "100 rows displayed (more data available)." How do I get all the rows?
2. Is there a way to save the results to a PC file? Presently, I'm doing a "Select All" and then copying into Excel.
TIA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwol
PvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=h4Mfc
nlwVmpRO5__XY7fKxflQmrVyFdvCxT1HWzD5uM&s=CbA2jk-lvYchYBV4XN85P2S-Efokl
1iFgOreL04RYrE&e= or email: MIDRANGE-L-request@xxxxxxxxxxxx Before
posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=h4MfcnlwVmpRO5__XY7fKxflQmrVyFdvCxT1HWzD5uM&s=vcpDZpK1CTHSyTE4VK4jzFSBvmhcnIH2hFYmWyxe4iQ&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJh
t2RKpmz7qvL2YDU_M-VhnRH6r43I&m=h4MfcnlwVmpRO5__XY7fKxflQmrVyFdvCxT1HWz
D5uM&s=clefbuyVdvqXsXgsunECDpRj03Govedar_GJphzQLRE&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=zZQvWAsKxkjN9gaXqiMjZqFpIvhoPqqgYwrmx_kpIIg&s=YKqHjQ95WaoTEvqaUdc12xAx2iLmUvjsPK5-8fdwI0g&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=zZQvWAsKxkjN9gaXqiMjZqFpIvhoPqqgYwrmx_kpIIg&s=qh-rcWt0OZGz0X7LueH6FjW1W19MbobfbK75eJIkWjg&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=zZQvWAsKxkjN9gaXqiMjZqFpIvhoPqqgYwrmx_kpIIg&s=UyJdWEoP6yqf2NLPPxma9l5oqgPM7s5mzZyUkC2Z258&e=
midrange.com
