qq_43278973的博客

DB2常用命令参考网址查看所有表名select * from syscat.tables;查看某个用户下的表select * from syscat.tables where OWNER=当前登录用户 and TYPE = 'T';DB2限制行数--查看前100条数据select * from test1 FETCH FIRST 100 ROWS ONLY;...

DB2前补零--前补零：right(digits(cast(A as integer)),10)参考网址

DB2生成自增ID--1) 创建测试表CREATE TABLE palan.db2_increment(A VARCHAR(255));--2）插入测试数据INSERT INTO palan.db2_increment VALUES('A');INSERT INTO palan.db2_increment VALUES('B');INSERT INTO palan.db2_increment VALUES('C');INSERT INTO palan.db2_increment VALU