|
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-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.