Habe ich gerade entdeckt ...
Man kann einen SELECT um einen UPDATE ... machen und dadurch das
"aktualisierte Ergebnis gleich holen.
Knut Stolze wrote:
Serge Rielau wrote:
UPDATE TABLE2 SET TS = CURRENT TIMESTAMP WHERE ID = (SELECT
FIELD1 FROM TABLE1 WHERE FIELD2 = {GET_VALUE_FROM_INPUT});
And then the SELECT from the UPDATE wouldn't be an issue anymore...
Oh, he wants to get the id back? No problem!
SELECT id FROM OLD TABLE(UPDATE TABLE2 SET TS = CURRENT TIMESTAMP WHERE
ID = (SELECT FIELD1 FROM TABLE1 WHERE FIELD2 = {GET_VALUE_FROM_INPUT}));
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
