Why not add the new columns to the old database, that's the way I have done it
That's what was supposed to have happened over time. Now, it would involve a
lot of manual work to determine the database structures in different instances
of the database -- and those instances are running 24 hours per day in STATICDB
OFF mode.--Larry
On Sunday, August 13, 2017 11:44 AM, Tom Hart <[email protected]> wrote:
Why not add the new columns to the old database, that's the way I have done
itTom Hart
On Aug 13, 2017 9:55 AM, "karentellef via RBASE-L" <[email protected]>
wrote:
I think what I'd do is project a temporary table, do the "unload all /
noschema" on the temp table, run the file in the new database, and then append
to the permanent table
Karen
-----Original Message-----
From: Buddy Walker <[email protected]>
To: rbase-l <[email protected]>
Sent: Sat, Aug 12, 2017 8:08 pm
Subject: RE: [RBASE-L] - Default to FILL for UNLOAD DATA
Larry Maybe I’m missing the point but why not LOAD table FROM filename USI
columnListHere Just make sure to exclude computed/autonum and any new
columns. Buddy From: 'Lawrence Lustig' via RBASE-L
[mailto:rbase-l@googlegroups. com]
Sent: Saturday, August 12, 2017 12:26 PM
To: [email protected]
Subject: [RBASE-L] - Default to FILL for UNLOAD DATA I'm trying to migrate a
database which involves doing UNLOAD DATA from the load database and running
the resulting files into a new database. In some tables, the new database
tables have a few fields added at the end of the table. R:Base is refusing to
load these tables because, when the unloaded files are created, they do not
include the FILL statement to populate "extra" columns on the LOAD. Is there a
way to either:
- Tell R:Base to include FILL in the UNLOAD DATA command OR
- Tell R:Base that, when processing a LOAD command, if neither FILL or
NOFILL is specified the default should be FILL instead of NOFILL?
--Larry --
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 rbase-l+unsubscribe@ googlegroups.com.
For more options, visit https://groups.google.com/d/ optout.--
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 rbase-l+unsubscribe@ googlegroups.com.
For more options, visit https://groups.google.com/d/ optout.
--
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 rbase-l+unsubscribe@ googlegroups.com.
For more options, visit https://groups.google.com/d/ optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
