About the Webinar

Converting Data Description Specifications (DDS) to Data Definition Language (DDL) SQL tables is a crucial step in modernizing database systems, particularly for organizations using IBM i (AS/400) systems. Impact Analysis is engineered to automate the conversion of Data Description Specifications (DDS) tables into Data Definition Language (DDL) SQL tables, thereby simplifying and streamlining database migration and management processes. It facilitates a seamless transition from traditional IBM i (AS/400) systems to modern relational database systems by addressing all critical aspects of the transformation.

Key Features:

  • Automatic Key Field Detection: The product identifies key fields and creates corresponding indexes.
  • Field Selection: It interprets the DDS structure to ensure only necessary fields are included in the final SQL structure.
  • Select Omit Handling: It accurately translates select-omit logic from DDS to ensure correct selection criteria are included in the SQL structure.
  • Logical File Structure Translation: The product replicates the relationships between physical and logical files in SQL, creating appropriate views and indexes.
  • Index and View Creation: The product automatically determines when to create indexes and views based on logical file dependencies, optimizing query performance and database organization.
  • Join Logical File Support: It recognizes and manages complex join operations used in logical files, converting them into accurate SQL JOIN statements.

This solution ensures a seamless and efficient migration from DDS to SQL, saving time, reducing errors, and preserving the original system logic.