Schema Mappings 
Author Message
 Schema Mappings
Hi,

I looking to try and find out how to(if it can be done) map multiple
schema names to a single schema name. I dont want to actually change
the names of the schema just to temporarily have Db2 see schema x and
schema y as being the same.
Currently looking into a way of importing SQL stored procedures from a
clearcase repository of one schema name into another DB that has
different schema names to the ones used in the procedures. In the
procedures there are only a couple of them that have schema names
hardcoded.

Thanks,
Ray



Mon, 16 Aug 2004 22:00:39 GMT
 Schema Mappings

Ray,

I don't thin,k you can map he schema neames themselves.

But you could create views under the new schema name for the appropriate
tables...

Quote:

> Hi,

> I looking to try and find out how to(if it can be done) map multiple
> schema names to a single schema name. I dont want to actually change
> the names of the schema just to temporarily have Db2 see schema x and
> schema y as being the same.
> Currently looking into a way of importing SQL stored procedures from a
> clearcase repository of one schema name into another DB that has
> different schema names to the ones used in the procedures. In the
> procedures there are only a couple of them that have schema names
> hardcoded.

> Thanks,
> Ray

--
====================================
To reply, delete the 'x' from my email

Jerry Stuckle
JDS Computer Training Corp.

====================================



Mon, 16 Aug 2004 22:41:45 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problems with XSD schema mapping to SQL Server schema

2. Looking for a schema to schema mapping tool

3. Using sql:is-constant and XSD Schema Mapping

4. beta SQL Annotated Schema mapping tool

5. Schema mapping

6. schema mapping problem with 2 primary keys

7. UML to ORDBMS Schema Mapping

8. Large complex schema - use schema mapping or FOR EXPLICIT?

9. Annotated schema mapping for "Choice" element instead of "Sequence" element

10. How to use annotated schema mapping without "URL"-type queries?

11. schema mapping problem. Urgent!! Thanks


 
Powered by phpBB® Forum Software