Will this work in case of two different database tables?
John Dbms <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/06/2001 01:14 PM MST
Please respond to db2eug
To: [EMAIL PROTECTED]
cc:
bcc:
Subject: Re: DB2EUG: Insert Into command in DB2
You could do:
INSERT INTO TABLE2 SELECT * FROM TABLE1
--- LeGrand Decius <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> Is there a DB2 SQL syntax to insert data from one
> database table to another database table.
> I would like to avoid exporting and importing data.
>
> This what I have in mind.
>
>
> Example:
>
> Database Names: (MEMDB1 and MEMDB2)
> UserName: test
> Schemas (tst and prod)
>
> connect to MEMDB1 user test;
>
> connect to MEMDB2 user test;
>
> insert into MEMDB1.tst.Specialty (id_number,
> specialty)
>
> select id_number, specialty from
> MEMDB2.prod.Specialty;
>
> disconnect current;
>
>
>
> Thanks in advance... I'm open to all recomendations.
>
>
>
>
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
