shmilywzc的专栏

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: ...

..........................

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...