| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 |
- Spring
- window
- xPlatform
- table
- Eclipse
- Java
- hadoop
- Python
- SPC
- es6
- NPM
- SSL
- vaadin
- IntelliJ
- Express
- plugin
- GIT
- 공정능력
- tomcat
- MSSQL
- Android
- Kotlin
- R
- react
- JavaScript
- 보조정렬
- Sqoop
- SQL
- mybatis
- mapreduce
- Today
- Total
목록database (66)
DBILITY
microsoft SQLServer XA설정시 Recovery권한 설정
sqlserver의 Binn에 sqljdbc_xa.dll 복사하고,xa_install.sql 실행 https://msdn.microsoft.com/en-us/library/aa342335.aspx
https://www-01.ibm.com/software/globalization/ccsid/ccsid_registered.html CCSID(decimal) CCSID(hex) Name 833 0341 KOREAN EBCDIC 933 03A5 KOREAN MIX EBCDIC 0418에러 중 한글조회가 안 될 경우 입력파라메터의 CCSID를 바꿔보세요.예) CAST ( ? AS VARCHAR(20) CCSID 933 )
http://docs.oracle.com/cd/E18283_01/server.112/e17120/tables004.htm
INSERT INTO TARGET_T WITH X AS ( SELECT~ ) SELECT COLS~ FROM SOURCE_T,X
db2 for iseries에 dg4odbc로 연결하기
이거 보고 광고 한번 안 누른 이는 삼대가 재수가 없을지어다!ㅋㅋ Gateway용 서버에 win64_11gR2_gateways 및 db2 for iSeries용 odbc driver 설치 1.odbc datasource system dsn name = db2 driver iSeries Access ODBC Driver select only check,naming rule sql,object description type sql object comments 2.initdb2.ora ( initSID.ora ) # This is a sample agent init file that contains the HS parameters that are # needed for the Database Gateway f..