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)

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

IBM공식사이트에서 다운로드하였습니다.