Skip to Content
avatar image
Former Member

Calling db procedure from multi source universe.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers