469,282 Members | 1,732 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

How update one row with timestamp diferent

Thanks to answer topic previous!!!!

I use this script to update one table

MERGE INTO EIS.CLI_HISTORY TXN
USING EIS.CLI_MAPING CLI
ON TXN.CLIENTID = CLI.CLIENTID
WHEN MATCHED AND
CLI.STATUSID = 3
AND CLI.CLIENTID != CLI.MAPPEDCLIENTID AND
CLI.CLIENTID = 24180 THEN
UPDATE
SET TXN.ISMERGED = 2,
TIMEACTUAL = CURRENT TIMESTAMP,
TXN.CLIENTID = CLI.MAPPEDCLIENTID;

But show problems of duplicate and the problem is with of row
TIMEACTUAL, because I don't put this row and the update was successful.

How I can update one row with TIMESTAMP but that is different. For
example

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.05

But I need that is diferent like this

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.06
Thanks to all !!!

Iván

Aug 25 '06 #1
3 6574
Hi, Ivan.

My apologies, but I'm afraid I don't understand what you're trying to
do and what problem(s) you're encountering. Can you take another crack
at describing the task at hand? I'm sure a solution exists, we just
need to nail down the requirements a bit.

Regards,

--Jeff

Ivan wrote:
Thanks to answer topic previous!!!!

I use this script to update one table

MERGE INTO EIS.CLI_HISTORY TXN
USING EIS.CLI_MAPING CLI
ON TXN.CLIENTID = CLI.CLIENTID
WHEN MATCHED AND
CLI.STATUSID = 3
AND CLI.CLIENTID != CLI.MAPPEDCLIENTID AND
CLI.CLIENTID = 24180 THEN
UPDATE
SET TXN.ISMERGED = 2,
TIMEACTUAL = CURRENT TIMESTAMP,
TXN.CLIENTID = CLI.MAPPEDCLIENTID;

But show problems of duplicate and the problem is with of row
TIMEACTUAL, because I don't put this row and the update was successful.

How I can update one row with TIMESTAMP but that is different. For
example

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.05

But I need that is diferent like this

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.06
Thanks to all !!!

Iván
Aug 25 '06 #2
Thanks!!!

I need update more of one row with Timestamp, for example mi script
extract 4 rows, and I need update these rows with diferent timestamp

Row1 TimeActual 2005-12-09-09.31.52
Row1 TimeActual 2005-12-09-09.31.53
Row1 TimeActual 2005-12-09-09.31.54
Row1 TimeActual 2005-12-09-09.31.55

I need that each row is different to be able to update my the table.

Hope is more clear.

Greetings
Iván

jefftyzzer wrote:
Hi, Ivan.

My apologies, but I'm afraid I don't understand what you're trying to
do and what problem(s) you're encountering. Can you take another crack
at describing the task at hand? I'm sure a solution exists, we just
need to nail down the requirements a bit.

Regards,

--Jeff

Ivan wrote:
Thanks to answer topic previous!!!!

I use this script to update one table

MERGE INTO EIS.CLI_HISTORY TXN
USING EIS.CLI_MAPING CLI
ON TXN.CLIENTID = CLI.CLIENTID
WHEN MATCHED AND
CLI.STATUSID = 3
AND CLI.CLIENTID != CLI.MAPPEDCLIENTID AND
CLI.CLIENTID = 24180 THEN
UPDATE
SET TXN.ISMERGED = 2,
TIMEACTUAL = CURRENT TIMESTAMP,
TXN.CLIENTID = CLI.MAPPEDCLIENTID;

But show problems of duplicate and the problem is with of row
TIMEACTUAL, because I don't put this row and the update was successful.

How I can update one row with TIMESTAMP but that is different. For
example

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.05

But I need that is diferent like this

TimeActual 2005-12-09-09.31.05
TimeActual 2005-12-09-09.31.06


Thanks to all !!!

Iván
Aug 28 '06 #3
Use TIMESTAMP(generate_unique())
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Harald Servat Gelabert | last post: by
9 posts views Thread by Mahesh S | last post: by
13 posts views Thread by dennis | last post: by
3 posts views Thread by Michel Esber | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.