I need to create a new universe which is very similar to an existing universe except the table name is different for each object. I can drag and drop classes and objects from the existing universe into the new universe and then change the table names relatively fast; however, when I create a new report and include a result object and click the SQL button I’m getting an error “The query does not reference a table”. Is this telling me there’s a hidden internal key that’s storing a reference to the table used in the structure window for each object? If this is true does anyone know of another way I can use the existing classes and objects?
If you are using Edit->Rename Table in Designer then make sure that the changes in table names are not reflected in complex definitions especially those including @aggregate_aware ,decode functions …Sometimes the Schema\ table names simply disappear leaving those object definitions invalid .Try running a Object Parse in the new Universe and then check for that query …if it helps …
Looks like you have only copied classes and objects.
You can simply duplicate the universe (File–>Save As) and the on every table, you can Right Click/Rename Table and change the table name.
Vasan
I need to create a new universe which is very similar to an existing universe except the table name is different for each object. I can drag and drop classes and objects from the existing universe into the new universe and then change the table names relatively fast; however, when I create a new report and include a result object and click the SQL button I’m getting an error “The query does not reference a table”. Is this telling me there’s a hidden internal key that’s storing a reference to the table used in the structure window for each object? If this is true does anyone know of another way I can use the existing classes and objects?
Kent,
Another option you could try is using table mapping in Supervisor to replace a table with another table. This should work as long as you do not have objects that are referring to objects that exist only in the original table.
This saves time in maintenance because you can update the original universe and make a copy for your other universe. The only thing you need to change for the duplicate universe is the possibly the universe longname and the filename.
Kurt Kerchner
SBC Communications Inc.
(314)340-9853
Fax#(314)235-4679
From: Kent Johnson[SMTP:johnsonka@WELLMARK.COM]
Sent: Tuesday, April 11, 2000 1:12 PM
I need to create a new universe which is very similar to an existing universe except the table name is different for each object. I can drag and drop classes and objects from the existing universe into the new universe and then change the table names relatively fast; however, when I create a new report and include a result object and click the SQL button I’m getting an error “The query does not reference a table”. Is this telling me there’s a hidden internal key that’s storing a reference to the table used in the structure window for each object? If this is true does anyone know of another way I can use the existing classes and objects?