Skip to Content
0
Former Member
Feb 06, 2012 at 06:23 AM

sql call

23 Views

- <payload operations="">
- <MT_Outlettest_B1 xmlns="http://xxxx.com/CD/B1/MasterData/Outlettest">
  <CreateDate />    
<DSTRB1 /> 
  <DSTRB2 />         
  <SCODE /> 
  <STATUS /> 
  <SALESORG /> 
  </MT_Outlettest_B1>
  </payload>
  <query id="httpheader.???" value="" /> 
  </call>
  </Payload>
- <Payload Role="C" id="atom1" system="0010000117" mode="single" method="Automatic detection by key word(Automatic detection by key word)" sql="SELECT CreateDate, T0.[U_DSTRB], T0.[U_DSTRB],T0.[U_SCODE], T0.[U_STATUS], T0.[U_SALESORG] FROM "@CW_PJP" T0 where datename(dw,CreateDate) = 'Monday'" disable-output-escaping="false">
- <ResultSet xmlns="urn:com.sap.b1i.adapter:jdbcadapter" rowCount="1">
- <Row>
  <CreateDate>2011-11-07 00:00:00.0</CreateDate> 
  <U_DSTRB>DMS_TEST</U_DSTRB> 
  <U_DSTRB>DMS_TEST</U_DSTRB> 
  <U_SCODE>1</U_SCODE> 
  <U_STATUS /> 
  <U_SALESORG /> 
  </Row>
  </ResultSet>
  </Payload>

Here when i am using sql cal the data is taking from table but its not set in paload operation

I have used this function

    <CreateDate>
						<xsl:value-of      select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row/jdbc:createdate"></xsl:value-of>
    </CreateDate>

but its not geting the value from result set of sql query.

Can any one help me?

Edited by: Sinha_Sinha on Feb 8, 2012 5:27 AM