Remove Schema name from Table Name

[IanWaterman]

I am using Cr8.5 on an Oracle 8 database.

My current client wants to move reports between different schemas. When you do a set location it prefixes the table name with the schema name. eg

SCHEMA1.TABLE_NAME when we reset location to a new schema it retains the old name and will not run giving a data base error - table not found.

Problem mainly manifests itself as reports are then integrated into a software package which defines the schema and table location. The reports will be used on an ASP model so it is important that reports can be moved from schema to schema seamlessly.

The only way we can overcome this is to manually go into set location and remove each schema prefix from the table location. This is both time consuming and subject to human error as a table may be missed out.

Is there a setting we can use to stop the schema name prefixing the table name. I have tried using the Update8x.exe package from CD, tis is great for mass updating location but it retains the original alias with the original schema prefix.

Thank you

Ian

 

[hilfy]

You have to go into the SQL (Database menu, View SQL) in the report and remove the schema name. We have three environments - Dev, QA, and Production - and this is how we make sure that the reports will run on any of the three without having to modify them.

-D

 

[vidru]

If you're calling the reports from code, you can remove and/or reset the schema at runtime.

-dave

 

[synapsevampire]

There isn't a setting to turn it off, and D's solution is sound, albeit a pain...

In later versions of CR you can use a parameter to pass schema names, table name, etc.

-k