Oninit cdi / Archive
Talk to an expert →

on External table

Posted in 2012

Summary

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.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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