|
Walden, I have tried that, QMQRY treats the &xxx as a literal, and no substitution is done. Not recognized as a variable. Rob, I set the values on the STRQMQRY command as follows, Literal: SETVAR ((LITVAL ''' place literal text here ''')) Character value field: SETVAR((CHARVAL ('''' *TCAT &CHAR_FIELD *TCAT '''') ) Number value field: SETVAR((NUMVAL &NUM_FIELD)) It seems to work well for me most times. Hope this helps! Jim ---------------------------------------------------------------------------------------------- Jim Essinger Senior Programmer/Analyst UnLtd Support Services PO Box 730 Fruitland ID 83619 208-452-4058 Ext 133 ---------------------------------------------------------------------------------------------- At 03:42 PM 8/17/2005 Wednesday, you wrote: Rob, What happens if you put single quotes in the QMQRY file? That is: INSERT INTO OUTQFIX VALUES('&OUTQFIX_OUTQ', '&OUTQFIX_AUTHLIST', '&OUTQFIX_CHANGED', '&OUTQFIX_MSGID') Does it then treat the &xxx as a literal, or does it still replace them? -Walden ------------ Walden H Leverich III Tech Software (516) 627-3800 x11 WaldenL@xxxxxxxxxxxxxxx http://www.TechSoftInc.com Quiquid latine dictum sit altum viditur. (Whatever is said in Latin seems profound.) -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [ mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx Sent: Wednesday, August 17, 2005 5:38 PM To: midrange-l@xxxxxxxxxxxx Subject: Can CL write to a disk file 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 -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
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.