Order By clause in Receiver JDBC adapter

[Former Member]

Hello All,

Is it possible to construct a select statement that uses an Order by clause in JDBC receiver adapter?

ex : I would like the JDBC adapter to from a query as follows:

<b>Select * from EMP where sal = 10000 order by empid</b>

We are able to construct the select statement without order by clause but not with it.

Can any one suggest me how to do it. This is bit urgent for us.

Thanks

Abinash

[MichalKrawczyk · Accepted solution]

hi,

did you try with

SQL_DML

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

Regards,

michal

[Former Member]

Thanks Michal

You are a Genious

All possible points to you.

Abinash