on External table
Posted in 2012
Frank asked whether inserting into an external table overwrites existing contents and how to keep rows. Art Kagel confirmed it overwrites and suggested renaming the underlying file and touching a new empty one between writes. Everett Mills suggested loading old data into a temp table and writing it back with the new data. Frank thanked both.
Topics: General Discussion
Hi, It seems inserting into a external table will overwrite its existing contents, correct? Can we avoid this( i.e., keep existing rows)? Thanks, Frank --14dae934105530a73504ce539628
CORRECT. One option: Rename the underlying file and touch a new empty one between writes to the external table. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Nov 12, 2012 at 5:11 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, > > It seems inserting into a external table will overwrite its existing > contents, correct? Can we avoid this( i.e., keep existing rows)? > > Thanks, Frank > > --14dae934105530a73504ce539628 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0401f591b62deb04ce541c5b
If the data's not too big you can load the old data into a temp table and dump it back to the external table with the new data you're writing. --EEM >-----Original Message----- >From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of >FRANK >Sent: Monday, November 12, 2012 4:12 PM >To: ids@iiug.org >Subject: on External table [28800] > >Hi, > >It seems inserting into a external table will overwrite its existing >contents, correct? Can we avoid this( i.e., keep existing rows)? > >Thanks, Frank > >--14dae934105530a73504ce539628 > > >************************************************************************ >******* > Forum Note: Use "Reply" to post a response in the discussion forum.
Thanks Art and Everett! Frank On Mon, Nov 12, 2012 at 5:54 PM, Everett Mills < Everett.Mills@nationalbeef.com> wrote: > If the data's not too big you can load the old data into a temp table and > dump > it back to the external table with the new data you're writing. > > --EEM > > >-----Original Message----- > >From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > >FRANK > >Sent: Monday, November 12, 2012 4:12 PM > >To: ids@iiug.org > >Subject: on External table [28800] > > > >Hi, > > > >It seems inserting into a external table will overwrite its existing > >contents, correct? Can we avoid this( i.e., keep existing rows)? > > > >Thanks, Frank > > > >--14dae934105530a73504ce539628 > > > > > >************************************************************************ > >******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04428c6ea2db4604ce659314