Re: sql update question

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.