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.


#TechXchangePresenter
 View Only

  • 1.  JDBC Adapter SelectSQL and Outer Joins

    Posted Wed November 03, 2010 09:38 AM

    Hello,

    Does anyone know if the JDBC Adpater supports Outer Joins using the SelectSQL template or do I have to use the CustomSQL template?

    Regards,
    Mathias


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: JDBC Adapter SelectSQL and Outer Joins

    Posted Mon April 11, 2011 02:06 PM

    Better use custom SQL template as this will provide freedom to perform any join u want …


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 3.  RE: JDBC Adapter SelectSQL and Outer Joins

    Posted Mon April 11, 2011 05:05 PM

    The select template supports outer joins.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 4.  RE: JDBC Adapter SelectSQL and Outer Joins

    Posted Mon June 27, 2011 08:58 PM

    I do not see how selectSQL Adapter Template can be used for outer joins. I would think you would simply change the operater for the join, I cannot get either Developer or Designer tochange the join operator to anything other than “=”.

    Anyone have any tips on this?

    Versions:
    wM 8.0.1.0
    JDBC Adapter 6.5 SP26.

    -Lohr


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: JDBC Adapter SelectSQL and Outer Joins

    Posted Tue June 28, 2011 05:51 PM

    My apologies. My post about support for outer joins is wrong.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 6.  RE: JDBC Adapter SelectSQL and Outer Joins

    Posted Wed June 29, 2011 03:19 PM

    Got it, customSQL Template for Outer Joins.


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


Related Content