![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
shmilywzc
这个作者很懒,什么都没留下…
展开
-
DB2 配置
DRIVER CLASS: com.ibm.db2.jcc.DB2Driver DRIVER LOCATION: db2jcc.jar and db2jcc_license_cu.jar (Both of these jars must be included) JDBC URL FORMAT: jdbc:db2://[:]/ JDBC URL Examples: ...原创 2011-10-26 14:39:57 · 194 阅读 · 0 评论 -
DB2 SQL
..........................原创 2012-01-06 13:47:41 · 75 阅读 · 0 评论 -
DB2 行转列
WITH t1 ( ISN, A1, B1, C1, A2, B2, C2) as ( SELECT ISN, substr(MEMBER_COVERAGE,1,8) A1, substr(MEMBER_COVERAGE,9,5) B1, substr(MEMBER_COVERAGE,14,5) C1, substr(MEMBER_COVERAGE,21,8) A2, subs...原创 2013-07-26 13:47:41 · 266 阅读 · 0 评论