× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: STRQMQRY
  • From: "Peter Dow" <pcdow@xxxxxxxxx>
  • Date: Wed, 26 Jan 2000 21:07:20 -0800

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.