Checking for Co-existence Tables

Before running the Table Conversion Workbench, you must check whether any of your tables are in Co-Existence (DDS) format. If you run Table Conversions against DDS format tables it will lead to data corruption and cause TCs to fail.

Use this procedure to check for co-existence tables:

1. Log on to the IBM i as QSECOFR.

2. On the command line, start a SQL session by entering this command:

   STRSQL

3. Run the following SQL statement, substituting in your Control Tables and Business Data library names

   SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE FROM SYSTABLES WHERE TABLE_SCHEMA 
   IN ('PRODCTL','PRODDTA') AND TABLE_TYPE = 'P' 
   

   where

   TABLE_TYPE='P' is DDS (World-created) tables

   TABLE_TYPE='T' is SQL (EnterpriseOne created) tables

   If there are DDS created tables in these libraries, you must follow the additional procedures in the Co-Existence Upgrade Guide (Doc ID: 702770.1), which is located on My Oracle Support.