DB2 equivalent for '@' in oracle

smauel · #1 (**permalink**) 07-09-09, 09:22

In oracle it is possible to run a sql script with the '@' command. What is the equivalent command in DB2?

Thanks
smauel

n_i · #2 (**permalink**) 07-09-09, 12:23

db2 -tf script.sql

dr_te_z · #3 (**permalink**) 07-10-09, 03:14

Not sure. In oracle you specify the"@" to point to tables on another server, right? In that case you need "federation" and "nicknames" in DB2. When you google for those you'll find out.

przytula_guy · #4 (**permalink**) 07-11-09, 03:09

also to execute in pl/sql a script
@catalog would execute catalog.sql

Internet Services

Web Development

Digital Marketing

Consumer Tech