Skip to Content
0
Former Member
Nov 07, 2006 at 03:38 PM

Order By clause in Receiver JDBC adapter

26 Views

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