Synonyms
A synonym is an alias or alternate name for a table,
view, sequence, or other schema object. Rational®
Integration Tester 8.5.1 or
later supports certain synonyms for some supported database management
systems.
The following table lists the database management systems supported by Rational Integration Tester and indicates the level of synonym support in 8.5.1 or later for each database.
| Database management system (DBMS) | Sequence synonym support | Stored procedure synonym support | Table synonym support | Synonyms that point to other synonyms support |
|---|---|---|---|---|
IBM® DB2® on distributed platforms (Linux, UNIX, and Windows) |
Yes |
(Not applicable) |
Yes |
Yes |
Db2 on IBM z/OS® |
(Not applicable) |
(Not applicable) |
Yes |
(Not applicable) |
Microsoft SQL Server |
No |
Yes |
Yes |
No |
MySQL |
(Not applicable because MySQL does not support synonyms) |
(Not applicable) |
(Not applicable) |
(Not applicable) |
Oracle |
Yes |
Yes |
Yes |
Yes |
Note: A synonym being learned becomes a entity in its own right
in a database stub and is no longer a synonym for other content in
the stub.