Skip to Content
avatar image
Former Member

JDBC

Experts,

1) Is it possible to do a JDBC lookup for Views ?

2) If I send a ID for a lookup and the respective ID is not maintained in Table, I am getting a Blank Value now, Is it possible to get the original valus which I sent for Lookup ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 14, 2009 at 03:37 PM

    Hey

    >>2) If I send a ID for a lookup and the respective ID is not maintained in Table, I am getting a Blank Value now

    If you are using PI 7.1 you will get pre-built Function for JDBC Look-up,use that function and after this standard function have a If-Else statement where you will see if value is blank(Compare with a blank constant) then map it with the original else map with the output of UDF.

    If you are using PI 7.0,then you need to write UDF for JDBC look-up,after this perform the same If-Else logic as explained above.

    Thanks

    Aamir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2009 at 04:10 AM

    Hi Edward,

    Yes it is possible to perform the lookup on Views.

    I think u can build a logic if the response is blank then u have the ID that u had sent, store the iDs for which u r getting blank response and use them.

    Thanks

    Sunil Singh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2009 at 04:00 PM

    HI

    Yeah it's posible. you can use a JDBC Adapter on SAP 7.1 or maybe build UDF in 7.0

    for more reference please chekc this blogs.

    /people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios

    jdbc-lookup

    /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

    Thanks

    Add comment
    10|10000 characters needed characters exceeded