Skip to Content
0
Former Member
Jan 10, 2008 at 02:43 PM

Order by in a select Statement ?

118 Views

Hi all,

In PI, I would like to translate this SQL Query in a select statement :

SELECT * FROM Table1

WHERE FIELD1 = val1 AND FIELD2 = val2

ORDER BY FIELD3 DESC

No problem for the beginning of the select statement with help of the following blogs :

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

it gives :

<StatementSelect>

<table name>

<access>

<col1>

<col2>

</access>

<Key>

</key>

</tablename>

My question is : How to implement the function ORDER BY in the key element ?

I was thinking about something like this :

<Key>

<Order_by>

<column_name>

</order_by>

<order_clause>DESC</order_clause>

</key>

or

<Key>

<order_clause>FIELD3</order_close>

</key>

But it seems that FIELD3 must be in the select condition...

Can someone help me plz ?

Thank you.

Edited by: Jean-Philippe PAIN on Jan 10, 2008 5:29 PM

Edited by: Jean-Philippe PAIN on Jan 10, 2008 5:30 PM