UPDATE SQL (DB2) with RAND function.

nsanjeevk · #1 (**permalink**) 03-02-06, 15:36

Hi,
Can someone please give me a UPDATE sql statement with RAND function in DB2. Basically I want to update one DB2 alphanumeric column with a random number. Appreciate your help.

Thanks.

Pat Phelan · #2 (**permalink**) 03-02-06, 15:52

Code:

UPDATE myTable
   SET myCharColumn = '42'

This will set this column to a random number (42) for all rows.

-PatP

nsanjeevk · #3 (**permalink**) 03-02-06, 16:05

Thanks Pat. But I want to put a different random number for each row. This will just give a number on each and every row of that column. The number should be unique.

Internet Services

Web Development

Digital Marketing

Consumer Tech