on 07-14-2009 4:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.