import / import_iwm_mail_addresses_stammdaten

Engine: Import
Source_Config: oster400_adminecomm
Target_Config: importEngine
Mysql_Engine: InnoDB
Default_Charset: utf8
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService

Queries:
 - Query:
     TargetDatapool: mail_addresses_stammdaten
     GetQuery: SELECT
               CAST(T1.PLKTOP AS VARCHAR(50)) AS PLKTOPs,
               CAST(T1.PLKNUM AS VARCHAR(50)) AS PLKNUMs,
               CAST(T1.PLANUM AS VARCHAR(50)) AS PLANUMs,
               T1.PLKNAM,
               TRIM(T1.PLEMAL) AS PLEMALT,
               T1.PLPEMA,
               T1.PLFILI,
               T1.PLFIRM,
               TRIM(T2.ADAVOR) AS VORNAME,
               TRIM(T2.ADNNAM) AS NACHNAME,
               T2.ADPL15,
               T2.ADLORT,
               T2.ADANRD,
               CASE
               WHEN T1.PLDERJ IS NULL OR T1.PLDERM IS NULL OR T1.PLDERT IS NULL
               OR T1.PLDERJ = 0 OR T1.PLDERM = 0 OR T1.PLDERT = 0
               OR T1.PLDERJ < 1000 OR T1.PLDERJ > 9999
               OR T1.PLDERM < 1 OR T1.PLDERM > 12
               OR T1.PLDERT < 1 OR T1.PLDERT > 31
               THEN NULL
               ELSE
               DATE(TIMESTAMP_FORMAT(
               LPAD(CAST(T1.PLDERT AS VARCHAR(2)), 2, '0') || '.' ||
               LPAD(CAST(T1.PLDERM AS VARCHAR(2)), 2, '0') || '.' ||
               CAST(T1.PLDERJ AS VARCHAR(4)),
               'DD.MM.YYYY'
                ))
               END AS PLDER
               FROM
               IWMOST1DTA.PLKA00 T1
               LEFT JOIN
               IWMADROLIB.ADRS01 T2 ON T1.PLANUM = T2.ADANUM
               WHERE
               TRIM(T1.PLEMAL) <> ''
               AND T1.PLSTAT = 'A'
               AND T1.PLEMAL IS NOT NULL