Example of Mapping script - SAMCHLD1.sqd - connect_cdc_sqdata - Latest

--  Map Table SQD_SAMCHLD1_NATIVE_LANG_TEXT
CREATE PROC M_SAMCHLD1 AS SELECT
{
 T_SAMCHLD1.ETL_SOURCE_APPLY_DTTM             = V_SOURCE-APPLY-DTTM
 T_SAMCHLD1.ETL_SOURCE_CAPTURE_DTTM           = V_SOURCE-CAPTURE-DTTM
 T_SAMCHLD1.ETL_SOURCE_CDC_ACTION_CODE        = V_SOURCE-CDC_ACTION-CODE
 T_SAMCHLD1.ETL_SOURCE_KEY                    = V_SOURCE-KEY
 T_SAMCHLD1.ETL_SOURCE_SYSTEM_INSTANCE        = V_SOURCE-SYSTEM-INSTANCE
 T_SAMCHLD1.ETL_SOURCE_SYSTEM_ORIGIN          = V_SOURCE-SYSTEM-ORIGIN
-- Parent Keys
 T_SAMCHLD1.RT_BRANCH                         = SAMPROOT.C2-BR-NO
 T_SAMCHLD1.RT_ACCT_OFFICER                   = SAMPROOT.RT-ACCT-OFFICER
-- Segment Key
 T_SAMCHLD1.C1_TEXT_LINE_NO                   = SAMCHLD1.C1-TEXT-LINE-NO
-- Segment Data
 T_SAMCHLD1.C1_RCRD_TYPE                      = SAMCHLD1.C1-RCRD-TYPE
 T_SAMCHLD1.C1_TEXT_LINE_TYPE                 = SAMCHLD1.C1-TEXT-LINE_TYPE

 if V_ENGINE_TYPE = 'U'
   T_SAMCHLD1.C1_NON_ROMAN_TEXT             = B2X(SAMCHLD1.C1-NON-ROMAN-TEXT,70)
 else
  T_SAMCHLD1.C1_NON_ROMAN_TEXT             = CONVERT_CCSID(SAMCHLD1.C1-NON-ROMAN-TEXT,1208,1200)
}
FROM CDCIN;