Resolving problems when using Data Analysis

Use the following advice to help you to resolve problems that can arise when you use Data Analysis.

About this task

'DOCID' and 'ID' columns are inserted into my database

Procedure

  • Scenario: You map your database to Data Analysis and the columns 'DOCID' and 'ID' are inserted into your database.
  • Explanation: The 'DOCID' and 'ID' columns are added to provide a unique key string for database operations. The 'DOCID' column is set to a unique string that you can use to identify the insertion of each entry into the database and remove if necessary. The 'ID' is the foreign key that links related tables together.
  • Solution: Works as designed.

No DDL script when using a z/OS® DB2® database

Procedure

  • Scenario: You complete the steps in the Generate DDL wizard, but the DDL script is empty.
  • Explanation: When the Check model option in the Generate DDL wizard is selected, the DDL script is not generated.
  • Solution: When you configure the DDL script in the Generate DDL wizard, do not select Check model.