| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
- xPlatform
- mapreduce
- hadoop
- GIT
- window
- 보조정렬
- Kotlin
- 공정능력
- vaadin
- IntelliJ
- react
- Express
- Java
- SSL
- plugin
- mybatis
- JavaScript
- tomcat
- NPM
- SPC
- Android
- SQL
- table
- Sqoop
- R
- Python
- Eclipse
- Spring
- es6
- MSSQL
- Today
- Total
목록2017/08 (2)
DBILITY
관리 툴 없이 TABLESPACE부터 생성하려니 몇 번의 명령어 오류를 경험하게 되었다. CREATE TABLESPACE TS_DEV DATAFILE 'D:\TOOLS\ORACLESTD1\ORADATA\ORA1\TS_DEV01.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M; CREATE TABLESPACE IX_DEV DATAFILE 'D:\TOOLS\ORACLESTD1\ORADATA\ORA1\IX_DEV01.DBF' SIZE 200M AUTOEXTEND ON NEXT 100M; CREATE USER DEV IDENTIFIED BY ****** DEFAULT TABLESPACE TS_DEV TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON TS_DEV..
http://ibmsystemsmag.com/CMSTemplates/IBMSystemsMag/Print.aspx?path=/ibmi/administrator/db2/SQL-Arrays-in-DB2-for-i-7-1 언젠가 사용할 지 몰라 붙여뒀다. Historically, to pass a list of values to or from an SQL procedure, you'd had a few options Use a long list of input and output parameters. Over time, the procedure's parameter list can become unbearably long and difficult to understand. Concatenate all the v..