General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Impacting Structure of one table on another
When I am developing I normally have several test areas with data in them and testers using them to test various aspects of my systems.
Changes in my development tables will normally have to be made to all my test tables.
In my 2.6 days I wrote a function called ImpStruc that Impacted the Structure of one table on another for me.
It worked as follows.
1. Get source and target information
2. Rename the target table
3. Use COPY STRUCTURE WITH CDX to create a new structure
4. Append the data in from the old (renamed) table.
Now I can not use the function because COPY STRU will convert my primary keys to candidate keys.
I would also have to remove the Target table from its DBC in order to carry out this operation and would lose various settings I have made at the DBC level.
Does anyone have some code that has the same functionality as my good old IMPSTRUC function.
I have searched through the files section to no avail. Although I have looked at one of Erik Moore's progs that generates the code for recreating the table.
It looks like this could do it with a bit of additional work.
I want to avoid that work However:)
All help no matter how trivial gratefully received.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only