Exporting Data

Once you have created SQL tables, you need data to test your applications. You may also need to distribute data to other Windows or UNIX machines or to send data back to the mainframe. IBM and other vendors provide products to do this. However, if you have not installed one of these products, moving data around can be a problem.

Host Compatibility Option supplies you with an Export Data tool that you can combine with DB2 Connect, IBM's DRDA gateway, giving you a relatively inexpensive way of moving data between mainframe databases and Windows or UNIX machines.