Hi All,
I have about 20 sources, one per country, named ApplicationNameXX DB, where XX is the country.
E.g. TOPSUK DB
I have a JDBC provisioning rule in place that calls a Stored Procedure. The Stored Procedure call is something like this:
call TOPSUK.dbo.kn_IDN_RemoveGroupFromUser(?,?)
I don´t want to create 20 provisioning rules one for each country. For this reason I want to include in the script behind the rule, a verification of what is the current source name being used, get the left chars from the source name, so TOPSUK, and use this in a variable in the Stored Procedure call, so:
call TOPSCountryvariable.dbo.kn_IDN_RemoveGroupFromUser(?,?)
How can I get the current source name in the script behind the JDBC provisioning rule?
Thanks,
BR, Andrea