Sven Köhler wrote:
> hi,
>
> is there something like INSERT UPDATE DUPLICATES, which does _not_
> replace the whole row, but only updates the given fields?
>
> i want to execute something like
> INSERT table(key, field) VALUES(1, 'text')
> if that fails, because of a key-collision, i should perform
> something like
> UPDATE table(field) VALUES('text') WHERE key=1
>
> is this possible somehow with one statement?
No, such a feature is not available.
There is only the straight-forward-way
INSERT --> if duplicate key then UPDATE
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
