Re: sql update question

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

David

Contact David Gibbs, perhaps he will have an idea or can analyze what is 
going on. I looked at the message source and saw something from 
somewhere that labeled your message with 8% probability of being 
unsolicited email. I did not take time to understand everything in 
there, because I don't really understand it.

Posts from others don't go through the same servers you do - that can 
make a difference, too, I think.

Good luck!
Vern

David FOXWELL wrote:
> Hi, 
>
> I'm sorry about posting this again, but something in my post is getting it labelled as spam. 
>
>
> I've done my update like so :
>
>
> /* Create temporary table with keyfields and derived field QENVID :
>
> CREATE TABLE QTEMP/T AS (                          
> SELECT 'ADH_' CONCAT SUBSTR ( DIGITS ( RANK() OVER ( ORDER BY QCLTDS, QADRDS )), 5, 16) QENVID, QLOTCD, QCLTDS, QADRDS, QADHNO  
>  FROM AVSENT ) WITH DATA                           
>
>
> /* Update the main table with the derived value in the temporary table :
>
> UPDATE AVSENT U                                              
> SET QENVID = (
> 	SELECT T.QENVID 
> 	FROM T 
> 	WHERE 
> 		 U.QLOTCD = T.QLOTCD AND
> 		 U.QCLTDS = T.QCLTDS AND
> 		 U.QADRDS = T.QADRDS AND
> 		 U.QADHNO = T.QADHNO 
> 		 ) 
>  
>
> I am a little worried that there may be an error in my code. If anyone  could point it out or suggest an easier method I would be obliged. Thanks.
>