Technical Issue with Records

[paulnlk4]

Hello,

Is there a statement in Teradata which can accomplish the following:

Insert records into a table if the record does not exist, however if the record exists, then update the record. Is there a statement like 'Insert with Update' option in TD. I heard of something similar in DB2. Please help.

Thnx
Paul

 

[tdatgod]

Hi,
yes. This was implemented in Teradata v2r4.1.

Syntax like

UPDATE Sales
SET ItemCount = ItemCount + 1
WHERE (ItemNbr = 10 AND SaleDate = ‘05/30/2000’)
ELSE INSERT
INTO Sales (10, ‘05/30/2000’, 1);

please see the SQL reference manual Volume 6 for V2r4.1.

http://www.info.ncr.com/sd/sd-1.cfm?page=td

select SQL reference then find the correct manual.

 

[paulnlk4]

Thanks tdatgod, as your name suggests, u r my saviour...Paul