Using the QCMDEXC scalar function, I came up with something that works. The three-part naming on the FROM causes ?everything? in the SELECT to be referenced on the remote system. (Terminology bad, serious brain fade on late Friday afternoon.)
SELECT CASE WHEN QSYS2.QCMDEXC('DSPFD FILE(DBALE/MDFX067RGL) TYPE(*BASATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(DBALE/TEST$DSPFD)') = 1
THEN 'DSPFD ran on REMOTEI'
ELSE 'DSPFD failed on REMOTEI'
END AS QCMDEXC_RESULT
FROM REMOTEI.SYSIBM.SYSDUMMY1 ;
Note that, in RSS, the DSPFD command string had to be on the same line to work. If the DSPFD command string was split into multiple lines, the SELECT " Statement ran successfully", but the result was 'DSPFD failed on REMOTEI'. When the DSPFD command string was contained on one line, the result was 'DSPFD ran on REMOTEI', and I found the DSPFD outfile created on the remote system.
I recognize this is a poor example because there is a Db2 table that has the information found in DSPFD; this was simply a demonstration that a command could be executed on a remote system from an SQL statement.
- Dan Bale
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Friday, March 21, 2025 4:12 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Automate spool download using ACS
Have you tried the old 'faking 3 part naming" technique?
www_linkedin_com/pulse/faking-3-part-naming-when-using-ibm-i-services-rob-berendt
On Fri, Mar 21, 2025 at 3:18 PM Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx>
wrote:
I've created several stored procedures to run queries using three-part
naming to remote systems, but I haven't figured out how to use that to
run commands on remote systems. What am I missing?
- Dan Bale
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***
midrange.com
