RE: iNav Run SQL Scripts

Run SQL Scripts is not like the others such as T-SQL. You have to create and then execute the procedure. It annoyed me the first time I started using IBM OS/400 SQL because I had started learning SQL using MS SQL Server and T-SQL.

SYSTABLESTAT should get you the row counts you are looking for without the need to loop through a data set.

-Matt


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Thursday, January 25, 2018 2:15 PM
To: Midrange-L <midrange-l@xxxxxxxxxxxx>
Subject: iNav Run SQL Scripts

I have a curiosity question in regards to the iNav Run SQL Scripts dialog window... What exactly constitutes an SQL Script from iNav's point of view? I have entered multiple, standalone SQL statements in the script window and executed those statements one at a time. But, what I would like to know is if you can enter multiple SQL statements that interact with each other (a.k.a., a compound SQL statement) in much the same manner as an internal SQL stored procedure?

I know I could create an actual stored procedure and then execute it, but I would like to be able to just enter the compound SQL statement (loops, calculations, variables, and all) and execute it without having to create an SQL object. Basically, I have a need right now to be able to spin through say, 600 libraries and count the number of rows in a like-named table in each of those libraries, accumulate the output into a temporary table, and then display the results at the end. Does the iNav
support that? I could just try it, but I thought I'd ask first. ;-)

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331



*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary information. If you have received this message in error, please immediately notify the sender and delete and destroy the message and all copies. All unauthorized direct or indirect use or disclosure of this message is strictly prohibited. No right to confidentiality or privilege is waived or lost by any error in transmission.
*********************************************************************************************
--
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=ddxNuaFb5LcMSIEOLJRsLBYsrElwI4kkofhs6lpLUvw&s=-g6G7G_KavBMHFKcQ93K4p_PBzCtiQ6RN70uB3LrLwA&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=ddxNuaFb5LcMSIEOLJRsLBYsrElwI4kkofhs6lpLUvw&s=oxQpc_VGfsfbOKFUHTNL9KB3Dp54MOIOoIJ417z41Zw&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=ddxNuaFb5LcMSIEOLJRsLBYsrElwI4kkofhs6lpLUvw&s=5yQZkgtSMSoNsWXgq1pNXp5aKzj49CRAatSXe0xdG9Y&e=