If you have SUPRTool version 4.6 or higher, you can accomplish this with
the TABLE command using the data option.  Feel free to contact me to
discuss how this can be done. 

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Dave Gale
Sent: Tuesday, April 18, 2006 6:17 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] QUERY

Kim:

It's been quite a while since I did something like this in QUERY. IIRC 
you have to do it in 2 passes. The first is to read the data and format 
a script that has the update values. Then run that script to do the
update.

As I haven't used QUERY syntax in years, so I know I would screw up an 
example, but the report phase would have to write the find and update as

well as the execute statement over and over. One for each update.

Yeah it's been a while but I know it can be done.

HTH

Dave


Kim Borgman wrote:
> Playing with query again.
>
>  
>
> I thought there was a way to replace a field in a data set with the
value in
> an existing field.
>
>  
>
> In this case, I need salesman(6) to go into salesman(7).
>
>  
>
> Tried update, replace salesman(7)=salesman(6);end 
>
>  
>
> Choked big time.....it's looking for literal value where salesman(6)
is....
>
>  
>
> Suggestions ?
>
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>   

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *