RE: Can CL write to a disk file

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

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