Thank You Razzak! ________________________________ From: [email protected] <[email protected]> on behalf of A. Razzak Memon <[email protected]> Sent: Tuesday, September 24, 2019 4:46 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Changing Column Data Type
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. -- 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/BY5PR18MB3105DEB56C7EE818C03A48E8D3840%40BY5PR18MB3105.namprd18.prod.outlook.com.
