none
how to genarate DB2 Request-Response schema having input& out prams RRS feed

  • General discussion

  • I'm utilizing the DB2 adapter in Biztalk 2009 to query data in a DB2 database on an iSeries machine.  It's working very well and the results of the query are correct.  The issue I'm having is that, I'm not at all sure how to utilize the results.  The issue is that all of the rows returned are placed into a node called "ResultSets" of type "anyType".  How do I get the rows from this "anyType" node out to work with (e.g. place into another message in an orchestration)?  Thank you in advance for any help.

    Wednesday, March 27, 2013 7:10 PM

All replies

  • Hi Srini,

    The only way to read the value is using xpath to an variable else use custom xslt for conversion from DB2 response to your own schema structure.

    I am working on DB2 adapter since 2011, i use to fetch the value using the DB2 adapter and using custom xslt i map the DB2 response to my own schema structure.

    Eg:

    If i got a DB2 response as:

     <DB2SelectResponse xmlns="http://DB2SelectRequestResponse">
    <Success>
     <ResultSets>
      <PRICER_LOG REP_SE_ID="GF" ROP_HFR_DL="1/16/2012 12:00:00 AM" TOT_CNT="11" />
      </ResultSets>
      </Success>
      </DB2SelectResponse>

    use Custom xslt:

    define the namesapce (xmlns:ns0="http://DB2SelectRequestResponse")

    <Policy>
     <xsl:value-of select="/ns0:DB2MBRSelectResponse/ns0:Success/ns0:ResultSets/ns0:REPRC_CNTL_LOG/@REP_SE_ID" />
    </Policy>

    like the above example we can map the DB2 response to the schema sctructure.


    Regards, Aboorva Raja R Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    Monday, April 8, 2013 12:25 PM