× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2019

RE: CL Commands in SQL

"QCMDEXC *PGM QSYS" <== NOT a stored procedure its an API on the system. Not certain what you are trying to tell me. I was commenting the point about suggesting a stored procedure that does not seem to exist.

-Matt


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

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.midrang
e.com&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1
Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Z
j5eClYpzqxPU&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.c
om_&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl
8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5
eClYpzqxPU&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.co
m_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwol
PvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4
DYDw8dFckd-eafFoRN_7Tg3V7Zj5eClYpzqxPU&s=d-8hrQC3116VvTJVUm4Gf48IhqY1c
25X8W1X-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.c
om&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8
HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=DoaG4DYDw8dFckd-eafFoRN_7Tg3V7Zj5e
ClYpzqxPU&s=BfmE7XiIp0FkLXrnKcaBL8Ui8_LYu3ZKKUnrVeu-F1E&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=9F6OHAo6RH3nR4bHQRs21rAcPkBxyh2Tw4LuO1eFwsU&s=IRpfFtHAyKc7nVB2sdwbR3jc-j4xxsaFrK0haZGgG-M&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=9F6OHAo6RH3nR4bHQRs21rAcPkBxyh2Tw4LuO1eFwsU&s=Ky64yB6o6w_2v_N33knKzAAaFSly27eRUNiRj4YFZTk&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=9F6OHAo6RH3nR4bHQRs21rAcPkBxyh2Tw4LuO1eFwsU&s=TjAVi_oYYKEXEwUNKUOPAcb56nBqA4d1C-eadeV_BrU&e=

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.