The Oracle SQL Developer tool can connect to databases other than Oracle, including MySQL, Microsoft SQL Server and DB2. The SQL development environment helps the programmer perform basic ...

We use linked servers in SQL Server 2000 (I know...) to pump data from an AS400 running DB2 in to some tables in SQL Server to do analysis. It is realy painful as the source system is a Danish ERP ...

SwisSQL 1.0 supports Oracle, DB2, SQL Server, MySQL, PostgreSQL and ANSI-SQL databases. Future releases will support Sybase Inc. and SAP databases.

I currently produce a data file on an AS400 for use in a SQL 2000 database.<BR><BR>I use the CPYTOIMPF command to produce a file from a query.

DB2DBUG Display of DB2 SQL Queries DB2 statements that appear in the SAS log are prepared and described in order to determine whether the DB2 table exists and can be accessed. DB2DECPT= decpoint-value ...

The next example creates the PROC SQL view VLIB.STOCKORD that is based on the table TESTID.ORDERS. The table TESTID.ORDERS is an SQL/DS table that is accessed through DRDA. libname vlib ...