RE: iACS-more data available

How is Squirrel better than ACS RSS for you?

-Matt


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Monday, January 15, 2018 4:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: iACS-more data available

Other than VE, I don't typically use Run SQL Scripts. SQuirreL is so much better for my purposes. Except in this case, where the JDBC driver didn't like the A.D. 2050+ dates in my query.




-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Monday, January 15, 2018 4: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


--
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=g7vUmfZzIntJXeoRN1GkPg-QxDqEJiU_mTuAXHv_GXI&s=AYooqfKIDvZ45AlemU2M-bbTbKbHUNIJn2Rm5I7W5VQ&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=g7vUmfZzIntJXeoRN1GkPg-QxDqEJiU_mTuAXHv_GXI&s=5IYzZYuG3-g4HgwKWJWYEW4TsVJMibG8Bf8-xeOYbcA&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=g7vUmfZzIntJXeoRN1GkPg-QxDqEJiU_mTuAXHv_GXI&s=T9MjyT2VVOIvevDdVJkEVMq2OKP6p4sLkjuqlYqvjKA&e=