on 03-05-2009 6:07 AM
Hi Friends,
Using JDBC lookup, I am trying to read from a table Emp1 using a user defined function. In PI 7.0, this function returns values of a single column only even if you fire a " Select * " query. I am planning to use a global variable(array) that stores individual column values of the records returned by a "select *" query. Need pointers on as to how a global variable can be declared and used to acheive the above scenario. Kindly explain with an example. Any help would be appreciated.
Thanks,
Amit.
Thank you all for the help. Highly appreciated !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
I am not sure but I thought this link will be useful to you which contains and webinar by William Li....regarding Mapping Enhancements. In this you can see JDBC look up in detailed manner..
[https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70d33e5c-e8c2-2a10-6397-c35172c8b280]]
Also check whether u can write one code seperately and may be u can go through Stored Procedure also right.
[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11749] [original link is broken] [original link is broken] [original link is broken];
Regards::
Amar Srinivas Eli
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Sounds like a good idea but then you would need an external db and update the table in a thread safe way !.
Regarding your question as to how to work with global variable please refer https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1352. [original link is broken] [original link is broken] [original link is broken]
Rgds
joel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.