Skip to Content
0

Calling db procedure from multi source universe.

May 17, 2017 at 09:00 AM

29

avatar image
Former Member

Hi everyone!

We are using one core universe (.unv) and there we have defined BEGIN_SQL parameter which is triggering security procedure on db and also forwards BOUSER info. And that works like a charm.

But now we have another multi-source universe in IDT which points to two different databases and we need to implement the same security. In Business Layer and in Data Foundation layer we only have general universe parameters where we can define our BEGIN_SQL parameter. But we need to define BEGIN_SQL parameter for each database, because we need to trigger the procedure on both databases.

And here I have a problem, nothing I tried worked. I even tried to define this on connection level where you have a option to define ConnectInit parameter and that actually triggers procedure but the problem is that ConnectInit parameter doesn't rollback session_id's and that raises the database error.

Did anybody had similar situation or do you maybe have any suggestions?

I would appreciate any suggestion and response. Thank you!

Kind Regards,

Kreso

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers