Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!bloom-beacon!mit-eddie!uw-beaver!tektronix!tekgen!sytek
From: sytek@tekgen.BV.TEK.COM (Mike Ewan)
Newsgroups: comp.databases
Subject: Re: File data imported into SQL db's
Message-ID: <3102@tekgen.BV.TEK.COM>
Date: 20 Jun 88 15:20:52 GMT
References: <236@tijc02.UUCP> <11410001@hpsmtc1.HP.COM>
Reply-To: sytek@tekgen.BV.TEK.COM (Mike Ewan)
Organization: Tektronix, Inc., Beaverton,  OR.
Lines: 15

In article <11410001@hpsmtc1.HP.COM> donovan@hpsmtc1.HP.COM (Donovan Hsieh) writes:
>In the article, David Marks <djm408@tijc02.UUCP> writes :
>
>>I have heard that some SQL databases can import fields from a file
>>into attributes of relations. ...
>
>I believe that many SQL based database provide such kind of import/export
>capabilities between external files and their database relations. HPSQL, a
>SQL based relational database from Hewlett-Packard provides LOAD & UNLOAD ...

UNIFY also has this capability.  They call it INSERT or UPDATE.  The syntax
is: insert into relation: from 'filename'/.  This works fairly well as the
file only needs to be ascii delimited with '|'.

(Assume usual disclaimers)