-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE fproblem (id INT PRIMARY KEY,x FLOAT(12,2));

INSERT INTO fproblem VALUES (1, 1000000000);

SELECT x FROM fproblem WHERE id=1;

UPDATE fproblem SET x=x+1000 WHERE id=1;

SELECT x FROM fproblem WHERE id=1;

DROP TABLE fproblem;
