시처럼 음악처럼

developerWorks Technical topics Information Management Technical library Port CONNECT BY to DB2 A recipe to map recursive queries from Oracle to DB2 using recursive common table expressions Using examples, this article describes step-by-step how to map CONNECT BY syntax and its associated pseudo columns to common table expressions that work in DB2® Universal Database™ (DB2 UDB) for Linux®, UNIX®..

/* Oracle ==> http://blog.naver.com/hyelee96/140073401311 */ WITH t AS ( SELECT 'A' gbn, '001' val FROM dual UNION ALL SELECT 'A' gbn, '002' val FROM dual UNION ALL SELECT 'A' gbn, '003' val FROM dual UNION ALL SELECT 'A' gbn, '004' val FROM dual UNION ALL SELECT 'A' gbn, '005' val FROM dual UNION ALL SELECT 'A' gbn, '011' val FROM dual UNION ALL SELECT 'B' gbn, '007' val FROM dual UNION ALL SEL..

JDBC ExcuteBatch 에러시 로그 파일 사이즈를 늘려준다. 실제로는 데이터 이상인 경우에도 동일한 에러를 뿌리므로 컬럼 사이즈및 타입을 먼저 확인해봐야한다. 로그 설정값 확인 SELECT * FROM SYSIBMADM.DBCFG WHERE NAME LIKE %log%; 트랜잭션 로그사용 확인 SELECT * FROM SYSIBMADM.LOG_UTILIZATION; UPDATE DATABASE CONFIGURATION FOR db_name USING LOGFILSIZ 1000 UPDATE DATABASE CONFIGURATION FOR db_name USING LOGPRIMARY 10 UPDATE DATABASE CONFIGURATION FOR db_name USING LOGSECOND 2

http://stackoverflow.com/questions/16910791/getting-error-code-4220-with-null-sql-state com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][3.65.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null I fixed the issue by using latest version of jar and by setting below system property . System.setProperty("db2.jcc.charsetDecoderEncoder"..