weixin_42076211的博客

执行命令db2 connect to databasename,出现SQL1117N  因为数据库处于 ROLL-FORWARD PENDING 状态，所以不能连接或激活数据库。执行如下命令：db2 rollforward db databasename stopdb2 rollforward db databasename to end of logs再次执行连接数据库命令db2 connect...

备份数据库时报错，SQL5005C，网上找的解决办法报错如下：A system error,probably an I/O error,was encountered while accessing a configuration file按照网上的方法，查找db2systm文件，不存在，可能是由于在清理C盘时误删了该文件，从别的服务器上复制一个过来就OK了。...

WITH  corp (CORPID, corpname, parentcorpid,corpstate) AS (  SELECTcorp1.CORPID,corp1.corpname, corp1.parentcorpid,corp1.corpstate FROM t_corpinfo corp1 wherecorp1.CORPID='null' UNION ALL  SELECT CHILD...

https://blog.youkuaiyun.com/f7anty/article/details/448575571.select date(trim(char('2009-09-01 '))),time(trim(char('12:23:34 '))),timestamp(trim(char('2009-02-26-14.28.40.234000')))from sysibm.dual2....

行转列sqlselect  max(case when char(crdate)='2016-06' then amt end )as amt1,max(case when char(crdate)='2016-07' then amt end )as amt1,     max(  case when char(crdate)='2016-08' then amt end) as amt2...

1.递归sqlWITH  corp (CORPID, corpname, parentcorpid,corpstate) AS (  SELECT        corp1.CORPID, corp1.corpname,corp1.parentcorpid,corp1.corpstate  FROMt_corpinfo corp1     where corp1.CORPID='null'...