Скачать или смотреть Using DB2 with ITX 10 via JDBC

In this demonstration, I take you through the steps required to access an IBM DB2 database from ITX 10 via the JDBC adapter. I use the Design Studio to create a simple map which does a simple JDBC query. I execute the map with both Design Studio and Command Server. The map uses the JDBC adapter, which connects to a JDBC driver (sourced from IBM) which then connects via TCP to a remote server running a DB2 instance.

In the video I document the JDBC adapter syntax, as well as giving hints on how to create Typetrees with the ODBC adapter.

JDBC rule :

=VALID(GET("JDBC","-URL jdbc:db2://localhost:50000/sample -USER db2admin -PASSWORD db2admin -TV -AS 0 -QTY * -LSN 0 -QUERY 'select * from Test1'"),LASTERRORMSG())