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
