Understanding DB2®: Learning Visually with Examples

12.10. Case Study

Assume your company wants to deploy a new accounting application very soon, but the finance department director has demanded a more thorough testing. The only test machine that is available for testing has DB2 for Windows installed. However, you need to obtain data from a DB2 for AIX database server. Since the source and target platforms are different and not every table and views are required for testing, you choose to use data movement utilities to move data to the Windows server.

First, you connect to the source server and then export the required tables with this command:

					export to newsalary.ixf of ixf
					messages newsalary.out
					select empno, firstnme, lastname, salary * 1.3 as new_salary
					from employee
					where workdept='A00' ...