How To
Summary
With the parameters "trim_char_to_varchar" and "trim_varchar_to_varchar" being enabled, CDC can trim character string from source char and varchar types to target varchar type. Because CDC considers "DBCS-OPEN" as MBCS type, which is a special type of char and varchar, it does not fall into the source char and varchar type column category. Therefore, these parameters do not apply to "DBCS-OPEN (MBCS)" type. Using %REPLACE expression, you can trim trailing space for a target column.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"ARM Category":[{"code":"a8m0z000000cws0AAA","label":"Db2 for i"}],"ARM Case Number":"TS010406127","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"11.3.0;11.4.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
07 October 2022
UID
ibm16827793