can strqmqry be run as remote command
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing
I am trying to run strqmqry via a dos/cmd ftp session.
command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ...
where ... are other options
I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for editing the sql which I did via iseries navigator).
here is snippet of my log file showing errors:
ftp> ftp>
QUOTE RCMD STRQMQRY QMQRY(SEIFEBR/BSTMSP1) QMFORM(SEIFEBR/BSTMSP1) SETVAR((FRMDT 1061030))
550-Error occurred on command STRQMQRY QMQRY(SEIFEBR/BSTMSP1) QMFORM(SEIFEBR/BSTMSP1) SETVAR((FRMDT.
550 Cause code is QWM2701; message text not available.
ftp> Invalid command.
--or--
QUOTE RCMD STRQMQRY QMQRY(SEIFEBR/BSTMSP1) OUTPUT(*OUTFILE) OUTFILE(CENUSRQRY/BSINTMSsHP) OUTMBR(*FIRST *REPLACE) SETVAR(FRMDT 1061030)
550-Error occurred on command STRQMQRY QMQRY(SEIFEBR/BSTMSP1) OUTPUT(*OUTFILE) OUTFILE(CENUSRQRY/BSI.
550 Error found on STRQMQRY command..
Help! and Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
November 8, 2006 4:52 PM
UPDATED:
November 9, 2006 12:18 PM
Answer Wiki:
I got it! Yes, it can be done this way. I finally decided to step through the proc again and my issue was when executing the command I was not properly quoting the variable. My initial presumption based on my research was that I did not need it... but I did. The example below required three sets of single quotes.
Anyways, thanks!
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
