Re: CL Commands in SQL

[Diego Kesselman <diegokesselman@xxxxxxxxx>]

Matt,

this is from WRKOBJ OBJ(*ALL/QCMDEX*) :

QCMDEXC     *PGM QSYS
QCMDEXC1    *PGM      QSYS2       CLE         SQL PROCEDURE QCMDEXC

Regards

Diego E. KESSELMAN


El 04/03/19 a las 14:56, Tyler, Matt escribió:
> 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=