Archives of the TeradataForum
Message Posted: Fri, 16 Jul 2004 @ 20:55:18 GMT
| Subj: || || Re: UPSERT Using Straight SQL |
| From: || || Dieter Noeth |
Chris Coffing wrote:
| ||I am trying to update / insert into a table from another table. Can I do this using an UPDATE (UPSERT FORM)???|| |
| ||So far I have not found a way to do this. It appears that the UPSERT form is looking for a parameter file to load from and does not
support a derived table and an INSERT / SELECT.|| |
Ins/Sel can't be used with Upsert.
You'll have to wait until Teradata supports the full "Merge Into" syntax from SQL:1999 with sets of data. The current Upsert/Merge
implementation only allows simple Inserts/Updates based on PI access.
You still have to use the traditional approach: "Update From" the existing rows and then "Insert/Select where not exists" the remaining