need sqlxml

[Former Member]

How can i create response sqlxml for below query....can anybody help me please..

select columnid

FROM tablename

WHERE column1 = 'Z' AND (column2 <> 'N' AND column2 <> 'M')

[Former Member · Accepted solution]

Hi Rahul,

Please check the below links...

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

These give you a very clear idea how to proceed..

Hope this helps

Regards

Kiran..

[Former Member · Accepted solution]

Do i need to use select or sql_query(sql_dml)?

[Former Member · Accepted solution]

Wrong blog link.

i read help.sap.com got confused.

Please somebody to give me more heads on.

[Former Member]

Rahul,

For executing select columnid

FROM tablename
WHERE column1 = 'Z' AND (column2 <> 'N' AND column2 <> 'M')

query in receiver JDBC adapter, you can use

<root>
StatementName4>

<dbTableName action=”SELECT”>

    <table>tablename</table>

<access>
<columnid></columnid>
</access>
<key1>
<column1>Z</column1>
<key2>
<column2 compareOperation=NEQ>N</column2>
<column2 compareOperation=NEQ>M</column2>
</key2>
</key1>
</dbTableName>  
  </StatementName4>
</root>

or

<root>
  <StatementName6>

<anyName action=” SQL_QUERY” >

<access>select columnid
FROM tablename
WHERE column1 = 'Z' AND (column2 <> 'N' AND column2 <> 'M'</access>
</anyName >  
  </StatementName6>
</root>

Hope this clears your doubt.

P.S: Close your previos thread regarding the same.

Regards,

Jai Shankar

[Former Member]

thanks jai.

using which is better?.

Can u please tell me the logic to write sqlxml?.

i read the help.sap.com docs....not getting much idea.

i got to write some complicated sql joins......

jai, can u email me... mysapep@gmail.com i need help.

[Former Member]

Rahul,

The logic to frame this is explained in the help.sap link given above.

>>using which is better?.

Depends on the developer's choice. If the query is very complex then go for a stored procedure and call the stored procedure from XI. I dont think there is a performance difference in using any of the different options avaialble.

U can find my mail id in my Business card.

Regards,

Jai Shankar

[Former Member]

i can't write stored procedure....as data is coming from old as400 db...

so what is my best choice?.