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.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=h4MfcnlwVmpRO5__XY7fKxflQmrVyFdvCxT1HWzD5uM&s=CbA2jk-lvYchYBV4XN85P2S-Efokl1iFgOreL04RYrE&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=h4MfcnlwVmpRO5__XY7fKxflQmrVyFdvCxT1HWzD5uM&s=clefbuyVdvqXsXgsunECDpRj03Govedar_GJphzQLRE&e=