Re: sql update

Hl Sheri,

Just have a look at the following article, published by Centerfield
Technologies:
Anatomy of a joined UPDATE
http://www.centerfieldtechnology.com/publications/archive/December%202006.pd
f
Page 9

The trick with joined updates is, for each row that must be updated the
select statement must return exactly 1 row.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Rowe, Sheri
Gesendet: Thursday, February 15, 2007 21:58
An: rpg400-l@xxxxxxxxxxxx
Betreff: Re: sql update


Thanks Santiago,

Unfortunately, this did not work (tried it both ways).  I received an error
message:  Null values not allowed in column or variable CMSTOR.  

I have since written a program as my Manager was getting perturbed.  It just
seemed like the perfect thing to do in SQL.  Thanks for your help anyway.

Sheri

*************************************************
date: Thu, 15 Feb 2007 18:58:36 +0100
from: Santiago G Mart? <smarti@xxxxxxxx>
subject: Re: sql update

This should work:

Update Customer a
       set Customer_Store = (select 'C'||Customer_Store from Customer where
Cust#=a.Cust# and Company=1)
       where Company=2

Perhaps you'd have to change it to: (select 'C'||substr(Customer_Store, 1,
n) from ...
where n is the length of field Customer_Store.


Saludos,
                  ---------------------------
                    Santiago Mart?
                       Dusen, S.A.
                  ---------------------------