[ic] Replacing SQL Databases

[interchange-users@interchange.redhat.com (Stefan Hornburg Racke]

Mike Heins <mheins@redhat.com> writes:

> Quoting Stefan Hornburg (Racke) (racke@linuxia.de):
> > 
> > Hello, Interchange users !
> > 
> > A customer of our company would like to upload a new databases where
> > many rows are deleted. This is no problem with text databases, you
> > just drop the new file and reconfig.
> > 
> > This don't work for SQL databases, only new records are added, but
> > the old ones with no counterpart in the upload stay there. Is there
> > a Interchange way instead of using SQL statements to achieve
> > database updates with deleting records ?
> 
> Yes, there is.
> 
> If you use the import page, which employs [import-fields ...], you can
> create a line in the update file which has:
> 
>     DELETE^Isku_in_question
> 
> The ^I represents a TAB, and the string DELETE starts the line. 
> 
> These can be intermixed with updated records.

Yes, that is a reasonable way. Thank you Mike ! Can anyone implement:

dump Mike Heins/Brain | grep interchange | bdoc2html :-)

Ciao
        Racke

-- 
Think of it !

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)