db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Walter Rogura <m...@sudus.eu>
Subject Re: COPY command
Date Tue, 03 Mar 2009 21:08:59 GMT
Hi Francois,

That is good stuff and what I need.

Thank you very much,
Walter

On Tue, 3 Mar 2009 10:29:39 -0800
Francois Orsini <francois.orsini@gmail.com> wrote:

> Hi Walter,
> 
> You can also import data from a text file with comma-separated fields
> using Derby's SYSCS_UTIL.SYSCS_IMPORT_DATA() built-in procedure...
> 
> CREATE TABLE TAB1 (c1 VARCHAR(30), c2 INT)
> CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', null, null,
> 'myfile.del',null, null, null, 0)
> 
> With myfile.del containing data sych as:
> Robert,1
> Mike,2
> Leo,3
> 
> More info at:
> http://db.apache.org/derby/docs/10.4/tools/tools-single.html#ctoolsimport16245
> 
> You can also create a table out of another existing table and specify
> which (if not all) columns you want to have:
> CREATE TABLE TAB1 AS SELECT c1, c2 FROM TAB3 WITH NO DATA;
> 
> You can find a list of Derby's SQL commands in the Reference guide:
> http://db.apache.org/derby/docs/10.4/ref/ref-single.html
> 
> Cheers
> 
> --francois
> 
> On Mon, Mar 2, 2009 at 3:40 PM, Walter Rogura <mist@sudus.eu> wrote:
> 
> > Hi,
> >
> > is there a COPY command applicable in derby? I know this from
> > PostgreSQL, e.g.
> > COPY table (column1, column2) FROM stdin;
> > c11     c12
> > c21     c22
> > c31     c32
> > \.
> >
> > I tried it with SQuirreL but had no success. Btw. where do I find a
> > reference of supported SQL commands in derby?
> >
> > Thank you very much,
> > Walter
> >

Mime
View raw message