RE: STRQMQRY

["Angela Wawrzaszek(EXCH)" <wawrzaszeka@xxxxxxxxxxx>]

I tried the semicolon but I get the same error of invalid token.  I tried
putting it on just the first update line then on both.  What did I miss?

UPDATE BPCSF/ITH SET TPFDV='J' WHERE TTYPE='J' AND TCLAS>='X1' AND
TCLAS<='X3';
UPDATE BPCSF/ITH SET TTYPE = 'A2' WHERE TPFDV = 'J' AND TTYPE = 'J',    
AND TCLAS >= 'X1' AND TCLAS <= 'X3';                                    
****************** End of data **************************************** 
 
 STRQMQRY QMQRY(AUSTEELLIB/MULTTRANS)                           
 Token ; was not valid. Valid tokens: <END-OF-STATEMENT>.       
 RUN QUERY command failed with SQLCODE -104.                    
 RUN QUERY command ended due to error.                          
 STRQMQRY command failed.                                       
                                                                
-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Peter Dow
Sent: Thursday, January 27, 2000 12:07 AM
To: MIDRANGE-L@midrange.com
Subject: Re: STRQMQRY


Hi Angela,

I don't know if you noticed, but I got your message posted about 6 times.

The answer is - use semicolon instead of period at the end of each update
statement. Weird that you should ask -- I just found this out about 2 hours
ago when I had the exact same problem.

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: Angela Wawrzaszek(EXCH) <wawrzaszeka@AUSTEEL.com>
To: Midrange mail list (E-mail) <midrange-L@midrange.com>
Sent: Monday, January 24, 2000 8:49 AM
Subject: STRQMQRY


> I am trying to create a multiple query source file that will update the
same
> file.  I have written qqmyqrysrc files that have 2 delete statements in
them
> but this is Update.
>
> Update library/myfile set var1='J' where var2 = 'J' and var3>= 'X1' and
var3
> <= 'X3'.
> Update library/myfile set var2='A2' where var1='J' and  var2 = 'J' and
> var3>='X1' and var3<='X3'
>
> If I don't put the period at the end of statement 1 I get invalid token
for
> "update" on line 2.  With the period I get token . not valid for end of
> statement.
>
>
> When I did this using the delete thats all I did was put a period at the
end
> of each statement, can't I have multiple updates within one source file?
I
> actually have 4 more lines to add to this, I just didn't want to have to
> execute multiple queries.
>
> Any help would be great!
>
> Angela Wawrzaszek
> Programmer/analyst
>  <<Angela Wawrzaszek(EXCH).vcf>>
>


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---