qq_37178232的博客

db2字符串分割函数

select substr(lower(hex(rand())),1,8)||'-'||substr(lower(hex(rand())),9,4)||'-'||substr(lower(hex(rand())),13,4)||'-'||substr(lower(hex(rand())),1,4)||'-'||substr(lower(hex(rand())),5,12)as uuid from sysibm.sysdummy1

实验环境:db2版本:DB2 v10.1.0.872db2客户端：Aqua Data Studio 19.0 - 64bit1、建立表并插入数据CREATE TABLE LEI.AREA ( CODE VARCHAR(100) NOT NULL, NAME VARCHAR(100), PARENTCODE VARCHAR(100), LEVEL INTEGER, PRIMARY KEY(CODE))GOCOMMENT ON COLUMN LEI.

环境：db2的客户端为Aqua Data Studio 19.0 - 64bit实例：比如给区域表(area)的code列添加备注 ‘行政区划代码’comment on column area.code is '行政区划代码'注意:结尾一定要记得不要加分号，不然会报在 “” 后面找到异常标记 ““行政区划代码””。预期标记可能包括：“MN AREA.CODE is”。. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29 错误...