db2 - 如何在 DB2 SQL 中生成 UUID

Question

我有一个表，我想在其中添加一个 UUID 列并为现有行插入 UUID。但我无法找到完成这项工作的方法。感谢您对此的投入。

标签： db2uuid

Answer 1

Db2 没有 UUID 列。改为使用生成的标识列。

CREATE TABLE TEST_GENERATED (I INT) IN USERSPACE1;
INSERT INTO TEST_GENERATED (I) VALUES 0, 0, 0;
SET INTEGRITY FOR TEST_GENERATED OFF;
ALTER TABLE TEST_GENERATED ADD ID INT NOT NULL WITH DEFAULT;
ALTER TABLE TEST_GENERATED ALTER ID DROP DEFAULT SET GENERATED ALWAYS AS IDENTITY;
SET INTEGRITY FOR TEST_GENERATED GENERATE IDENTITY IMMEDIATE CHECKED NOT INCREMENTAL;
INSERT INTO TEST_GENERATED (I) VALUES 1, 1, 1;
SELECT * FROM TEST_GENERATED;

|I          |ID         |
|-----------|-----------|
|0          |1          |
|0          |2          |
|0          |3          |
|1          |4          |
|1          |5          |
|1          |6          |