Ispirer Ispirer
 


Ispirer Home Page Request SQLWays

Convert Multi-Member Tables from DB2 AS400

To convert Multi-Member Tables from DB2 iSeries using the Ispirer SQLWays Wizard we need to follow the steps described in this article.

Create Aliases on Members

First of all we need to identify the list of members created on a specific table. And then create aliases for each member, using the query:

 CREATE ALIAS MYLIB.FILE1MBR1 FOR MYLIB.MYFILE(MBR1);
 CREATE ALIAS MYLIB.FILE1MBR2 FOR MYLIB.MYFILE(MBR2);

Such aliases should be created for all members for each multi-member table that we need to migrate during our migration project. In other case not all the data will be extracted from multi-member tables.

Use Query

After all the aliases were created, we need to run the SQLWays Wizard tool and choose “Use Query”, on the “Specify Objects” page, like it is done on the screenshot:

Then we need to specify select query, that will be used to select the data from all the members created on the table. And also set a target table name in the second column. Please see the example:

You can specify multiple queries and extract data from all the multi-membered tables that you have in your source database. To add or remove query please use buttons “Add Query” and “Remove Query” accordingly.

Run the Migration

After providing the queries to the created aliases we just need to run the conversion process and our tool will extract all the data from the tables and will generate correct table definition, that will be loaded into the target database.



If you will have additional questions regarding the migration of multi-member tables from DB2 AS400, please contact our support team: support@ispirer.com


Ispirer Home Page Request SQLWays

sqlways/specifics/ibm-db2/multi-member-tables/convert-multi-member-tables.txt · Last modified: May 07, 2018, 03:15:36 PM (external edit)
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement