|
Is there a command like SNDF that will work to a disk file? V5R3.
Trying workarounds like
CHGVAR VAR(&OUTQFIX_OUTQ) VALUE('A')
CHGVAR VAR(&OUTQFIX_AUTHLIST) VALUE('A')
CHGVAR VAR(&OUTQFIX_CHANGED) VALUE('A')
CHGVAR VAR(&OUTQFIX_MSGID) VALUE('A')
STRQMQRY QMQRY(OUTQFIX) +
SETVAR((OUTQFIX_OUTQ &OUTQFIX_OUTQ) +
(OUTQFIX_AUTHLIST &OUTQFIX_AUTHLIST) +
(OUTQFIX_CHANGED &OUTQFIX_CHANGED) +
(OUTQFIX_MSGID &OUTQFIX_MSGID))
Which executes
INSERT INTO OUTQFIX
VALUES(&OUTQFIX_OUTQ, &OUTQFIX_AUTHLIST, &OUTQFIX_CHANGED,
&OUTQFIX_MSGID)
But I get stupid messages like:
CALL ROB/TESTFIX
215 - STRQMQRY QMQRY(OUTQFIX) SETVAR((OUTQFIX_OUTQ 'A')
(OUTQFIX_AUTHLIST 'A') (OUTQFIX_CHANGED 'A') (OUTQFIX_MSGID 'A'))
Column A not in specified tables.
RUN QUERY command failed with SQLCODE -206.
And I'm just plain disgusted playing the apostrophe game.
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.