JDBC to Proxy

[Former Member]

I am doing a scenario from JDBC to proxy. I have to select few records and send to proxy. There are two types of records say A and B and type is a mandatory field in each record. I have to arrange these records according to type and place all A type records above B type records. How can i do this with graphical mapping?

[Former Member · Accepted solution]

Hi ,

You can use Sort function for the same

Regards

[Former Member]

Hello Jaya,

Whatever order you are receiving from sender side , you can send it to receiver side as it is. or if you want to do sort on a field then you have standard functions Sort or sort by key.

Other wise use UDF and in UDF you can use Vector and do the sort and return to the result list and send it to receiver.

With Regards,

Raju.

Please award points if useful...

[Former Member]

thankyou....