JDBC

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

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

Thanks

[sunil_singh13]

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