Hi All,
I have the fresh entry into this forum.
I am developing reports for SQL server agent. In my design, i need to support for all the databases. But
some of table names are different in different databases.
In one of my report I am trying to replace the table name based on the database connection. For example, in
DB2 and SQL I am using the table namely "MS_SQL_Lock_Resource_Type_Summary". But the table name is different
in Oracle, i.e., "KOQLRTS".
In run time the table name has to be replaced based on the connection to database, that is if i connected to
Oracle the data should fetch from "KOQLRTS" table, if i connected to DB2 or SQL then the data should fetch
from "MS_SQL_Lock_Resource_Type_Summary".
Please help me to achieve this, using any sql query or java script.
Thanks in advance.
Santhosh
