Anne,
There are different techniques to accomplish your task.
However, in a situation like yours, the most efficient way is to
first UNLOAD STRUCTURE and UNLOAD DATA into to separate files. Then,
make all necessary changes in the STRUCTURE file accordingly and
rebuild the database.
-- Example
CONNECT dbname
OUTPUT Structure.str ; UNLOAD STRUCTURE ; OUTPUT SCREEN
OUTPUT Data.dat ; UNLOAD DATA ; OUTPUT SCREEN
DISCONNECT
RENAME dbname.rx? dbname_backup.rx?
RBEDIT Structure.str
-- Carefully, make all structural changes
-- Save the file
RUN Structure.str
RUN Data.dat
That's all there is to it.
Have fun!
Very Best R:egards,
Razzak
At 04:31 PM 9/24/2019, Anne Cusmano wrote:
What would be the correct way to change a column data type in which
the column is used in multiple tables?
Thank You
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201909242046.x8OKkWmp022516%40atl4mhob14.registeredsite.com.
