Javier,
You have answered your own question.
Here's the classic approach (my favorite) :)
01. CONNECT dbname IDENTIFIED BY password
OUTPUT dbname.STR
UNLOAD STRUCTURE
OUTPUT SCREEN
OUTPUT dbname.dat
UNLOAD DATA
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rx? dbname_backup_yyyymmdd.rx?
RBEDIT dbname.STR
-- Search and replace the column values as you see fit and save the file
RUN dbname.STR
-- this will build the empty shell
LIST COLUMN colname
-- verify all updated columns
RUN dbname.DAT
-- to load data
02. Make sure to use the RELOAD routine to refresh all INDEXes.
That's all there is to it!
Have fun!
Very Best R:egards,
Razzak
At 09:32 PM 7/1/2021, [email protected] wrote:
I need to change the size of a column in a table from TEXT 9 to TEXT
20; actually and unfortunately, there are 60 instances of this
column in the database. I did write a utility once upon a time that
did a lot of renaming when multiple occurrence of the column were
present and, if I recall correctly made it available to forum
members that needed that functionality. It was many, many year ago
and I will have to search my old laptops to see if I can find it.
Does the recent version include by any chance a utility to do this?
If not, does anyone have an easy way to do this?
My workaround might be downloading the database structure and data
and changing the length there and reloading the whole thing. Any
help or advise will be appreciated.
Javier,
Javier Valencia, PE
913-915-3137
--
For group guidelines, visit
<http://www.rbase.com/support/usersgroup_guidelines.php>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
<mailto:[email protected]>[email protected].
To view this discussion on the web visit
<https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAL7VjDBKqH5Ol0xHMlpKyAQBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer>https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAL7VjDBKqH5Ol0xHMlpKyAQBAAAAAA%3D%3D%40vtgonline.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/0MCKxT-1m8Acs0PRp-00968J%40mrelay.perfora.net.
