DBILITY

이거 보고 광고 한번 안 누른 이는 삼대가 재수가 없을지어다!ㅋㅋ 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)

weblogic 12c developer사용시 eclipse, intellij에서 연동할때 서버속성에 추가 #서버용 클래스패스 CLASSPATH %CLASSPATH%;C:\Dev64\maven\repository\com\ibm\as400\access\AS400JDBCDriver\1.0\AS400JDBCDriver-1.0.jar #console 한글깨짐방지 EXTRA_JAVA_PROPERTIES -Dfile.encoding=UTF8 -Dfile.client.encoding=UTF8 #메모리설정 USER_MEM_ARGS -XX:PermSize=128m -XX:MaxPermSize=256m -Xms1024m -Xmx1024m -XX:NewRatio=2 -XX:+UseParallelGC -XX:-UseConcM..

Master Note for Oracle Gateway Products 1. Concepts and Availability Oracle Gateway products are based on Heterogeneous Services and allow access to non-Oracle databases from Oracle products.Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as t..

오라클에서 테스트되었습니다. UI에서 comma로 연결된 argument를 입력받아 분리 후 행으로 변환하여 조건으로 공급하는 SQL에 응용하였던 적이 있습니다. WITH T1 ( CN ) AS ( SELECT ','||TRIM('A1,A2,A3,A4,') FROM DUAL ) SELECT SUBSTR(T1.CN,INSTR(T1.CN,',',1,LEVEL)+1,INSTR(T1.CN,',',1,LEVEL+1)-INSTR(T1.CN,',',1,LEVEL)-1)CN FROM T1 CONNECT BY LEVEL