RE: CL Commands in SQL

Odd, because I do not find a QSYS version of QCMDEXC stored procedure. So if you are allowed to run QSYS.CMDEXC() then IBM is doing something to the call and finding the QSYS2 version. For me i cannot run a procedure named QSYS.QCMDEXC(). Its not found.

-Matt


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Kevin Adler
Sent: Monday, March 4, 2019 1:49 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: CL Commands in SQL

The second, actually. Dave previously said he was using the QSYS2 version
while I was trying to suggest using the QSYS version.
 

----- Original message -----
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Cc:
Subject: Re: CL Commands in SQL
Date: Mon, Mar 4, 2019 2:28 PM
 
On Mon, Mar 4, 2019 at 2:54 PM Kevin Adler <kadler@xxxxxxxxxx> wrote:
>
>    The only thing I could think of is using QSYS.QCMDEXC instead of
>    QSYS.QCMDEXC.

I think the first of those was supposed to be QSYS2.QCMDEXC?

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [1]https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=d-8hrQC3116VvTJVUm4Gf48IhqY1c25X8W1X-9vXW6E&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [2]https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=yYaup4yy93RsiHIf4UpLXtEWfaTOQqJhJ1VbLbC4mho&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: [3]https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=BfmE7XiIp0FkLXrnKcaBL8Ui8_LYu3ZKKUnrVeu-F1E&e=
 

 

References

Visible links
1. https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=d-8hrQC3116VvTJVUm4Gf48IhqY1c25X8W1X-9vXW6E&e=
2. https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=yYaup4yy93RsiHIf4UpLXtEWfaTOQqJhJ1VbLbC4mho&e=
3. https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com_&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=v0MhXhGG7DYFPXrtBnWhmIhyaZmHWXBKAiR99v8Kb7E&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx 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=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=d-8hrQC3116VvTJVUm4Gf48IhqY1c25X8W1X-9vXW6E&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=yYaup4yy93RsiHIf4UpLXtEWfaTOQqJhJ1VbLbC4mho&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=https-3A__amazon.midrange.com&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=BfmE7XiIp0FkLXrnKcaBL8Ui8_LYu3ZKKUnrVeu-F1E&e=