Oninit cdi / Archive
Talk to an expert →

on External table

Posted in 2012

Topics: General Discussion

FRANK — — source: IIUG Forums & Mailing Lists

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

↪ replying to FRANK
Art Kagel — — source: IIUG Forums & Mailing Lists

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

↪ replying to FRANK
Everett Mills — — source: IIUG Forums & Mailing Lists

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.

↪ replying to Everett Mills
FRANK — — source: IIUG Forums & Mailing Lists

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