Date w/century to std fmt - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method:   Date w/century to std fmt

Function name:   de_century_to_standard_date

Parameter list:   (CHAR input)

Return type:   CHAR

What the method does:    Converts a source date value of the form CYYMMDD (where C is century, Y is year, M is month, and D is day) to a value in the form YYYYMMDD. The century value, 0 or 1, is converted to 19 or 20, respectively; the remaining characters in the string are left unchanged.

The method is designed for db2/400 source data that is stored in a DECIMAL(7,0) datatype, not in a DATE or TIMESTAMP datatype. If source column strings have null or missing string characters, or in case of error, the method returns a null.

Note: This method can only be used in a result expression. It cannot be used in a gate condition. This is because when the code is generated it uses the target column length in its processing of the value. Therefore, this method would not be relevant for a gate condition since there is no target column associated with it.