Skip to Content
avatar image
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

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    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

  • avatar image
    Former Member
    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

  • avatar image
    Former Member
    Jul 27, 2007 at 09:47 AM

    thankyou....

    Add comment
    10|10000 characters needed characters exceeded