Skip to Content
author's profile photo Former Member
Former Member

JDBC to Proxy

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?

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2007 at 09:32 AM

    Hi ,

    You can use Sort function for the same

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2007 at 09:49 AM

    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...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2007 at 09:47 AM

    thankyou....

    Add comment
    10|10000 characters needed characters exceeded