IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  getting problem while mapping element of type Date...

    Posted 09/12/07 09:41 AM

    Originally posted by: adsdd


    I m mapping AnyDate of FlexibleDatesType To transactionDate as mentioned in source and destination respectivley...
    But While excuting map, WTX is not able to map it.

    i m using TEXTTODATE function.
    I m passing AnyDate as argument to this function.As I m not getting any error.But transaction element contains no value...
    e.g.
    <AnyDate>2003-08-13</AnyDate> ------> <transactionDate></transactionDate>
    For ur reference I m putting schema defination..
    Source:
    <xsd:complexType name="FlexibleDatesType">
    <xsd:choice>
    <xsd:element name="AnyDate" type="AnyDateTimeNkNaType"/>
    <xsd:element name="YearMonth" type="xsd:gYearMonth"/>
    <xsd:element name="Year" type="xsd:gYear"/>
    <xsd:element name="MonthDay" type="xsd:gMonthDay"/>
    <xsd:element name="StringDate" type="xsd:string"/>
    </xsd:choice>
    <xsd:attribute name="dateDescription" type="xsd:string"/>
    </xsd:complexType>

    <xsd:simpleType name="AnyDateTimeNkNaType">
    <xsd:union memberTypes="LocalDateType DateType LocalDateTimeType DateTimeType NotKnownLiteral NotApplicableLiteral"/>
    </xsd:simpleType>

    <xsd:simpleType name="LocalDateNkNaType">
    <xsd:union memberTypes="LocalDateType NotKnownLiteral NotApplicableLiteral"/>
    </xsd:simpleType>

    <xsd:simpleType name="LocalDateType">
    <xsd:restriction base="xsd:date">
    <xsd:pattern value="\d\d\d\d-\d\d-\d\d"/>
    </xsd:restriction>
    </xsd:simpleType>

    destination:

    <xsd:element name="transactionDate" type="xsd:date"/>
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: getting problem while mapping element of type Date...

    Posted 09/12/07 09:45 AM

    Originally posted by: janhess


    TEXTTODATE expects a format of CCYYMMDD or YYMMDD.
    Use TODATETIME(AnyDate,"{CCYY-MM-DD}")
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: getting problem while mapping element of type Date...

    Posted 09/13/07 02:14 AM