QDDS Conversion Step

Introduction

In IBM i systems, users share their data definitions system-to-system by transferring DDM (Distributed Data Management) configurations. DDM allows programs on one system to work with files stored on another system, while QDDS files contain the DDM information, including both data and metadata definitions. These QDDS files are typically packaged into a SAVF archive file for easy distribution and are provided by the customer.

The Data Migrator supports these QDDS files and converts them into EBCDIC files. This QDDS-to-EBCDIC transformation is a crucial preprocessing step that prepares the data for the subsequent Data Loading Step, where the converted EBCDIC files can be properly imported into the target system.

Properties

Property name	Description	Values	Default value	Mandatory
input.folder	The data conversion input folder	String	None	Yes
output.folder	The data conversion output folder	String	None	Yes
enable	Whether the step is enabled	true/false	true	No
encoding	Encoding to considerer when reading files	String	Value of property defined in global step	No
ignoreLogicallyDeletedRecords	To ignore a record (row) which is marked logically as deleted	true/false	false	No
multithread	Number of threads to use for parallel steps	Integer	Value of property defined in global step	No

Example

The following setting illustrates the configuration settings for the QDDS conversion step

[ConvertQDDS - Conversion1]
encoding=CP037
input.folder=data/inputs
output.folder=data/DataFiles

This configuration section specifies:

CP037 encodes the characters when reading input files
data/inputs serves as the source directory for files awaiting conversion
data/DataFiles serves as the target directory to store the converted data