| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
- Kotlin
- SSL
- Express
- mapreduce
- SQL
- Eclipse
- SPC
- NPM
- react
- Spring
- mybatis
- hadoop
- 보조정렬
- Java
- window
- es6
- Sqoop
- JavaScript
- table
- vaadin
- MSSQL
- plugin
- xPlatform
- Android
- tomcat
- Python
- GIT
- IntelliJ
- R
- 공정능력
- Today
- Total
목록database (65)
DBILITY
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..
SELECT * FROM TABLE_NAME AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '10' MINUTE)