Access 2 different databases from one SQL script

echogovadze · #1 (**permalink**) 10-19-11, 05:35

Hi,

I wander if i can write INSERT statment, which selects data from table that exists in database1 into table that exists in database2? If yes - what syntax should i use?

It is so simple in TSQL... but does not work in DB2

Thanks in advance!

Eka

Marcus_A · #2 (**permalink**) 10-19-11, 05:40

Go to DB2 manuals and search on Federation.

Internet Services

Web Development

Digital Marketing

Consumer Tech