IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Very Very URGENT - Problem with brokerDate field

  • 1.  Very Very URGENT - Problem with brokerDate field

    Posted Fri December 28, 2001 08:58 AM

    Hello,
    We are using Enterprise Server 4.1.1 with Oracle
    Intelligent adapter. We
    have configured INSERT operation with a date field.
    The INSERT operation
    takes brokerDate data type by default. I cannot change
    the data type of
    this INSERT field. When the operation is executed, it
    does not give any
    error, but when I execute ‘select orderdate,
    to_char(orderdate, ‘dd-mm-yy’)
    from orders’ in SQLPlus, I see following output.

    ORDERDATE TO_CHAR(

    18-NOV-01 00-00-00
    18-NOV-01 00-00-00
    00-DECEMB 00-00-00

    Note that the day, month, year all are coming as 00
    values. Why is it? Any
    solution?
    Answers ASAP is appreciated.
    Regards,
    -Vandana.


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


  • 2.  RE: Very Very URGENT - Problem with brokerDate field

    Posted Fri December 28, 2001 03:32 PM

    Use Custome SQL Operation with date field as String instead of BrokerDate.

    In our one of the integration we were facing same problem with Select SQL operation where there was a date field in where clause. We used String field for it and it worked. In Insert Operation Template you can not change BrokerDate to String so use custome SQL Operation instead of that.

    This should solve ur problem.


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


Related Content