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:[email protected]] 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 [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. -- 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.
