calling a file from a .bat file

nittal · #1 (**permalink**) 08-27-08, 07:11

Hi all,
m using db2 v8.1 ESE on windows
needed to know how we call another file(say abc.sql) from a batch file and how do we capture the output from this abc.sql file in another file.

przytula_guy · #2 (**permalink**) 08-27-08, 07:14

db2 -tvf xxxx.sql > output.out
or option -o xxxx
see reference for details

nittal · #3 (**permalink**) 08-27-08, 07:21

i dont want to run this xxx.sql file directly from CLP but want to execute it inside another file. giving the above said command in this file throws an error saying 'an unexpected token db2 found'

przytula_guy · #4 (**permalink**) 08-27-08, 08:31

from a bat file you can only call db2 commands with db2 -tvf xxx and not directly. if this has been started from db2 command window
see db2cmd in reference or previous discussion on bat files
see : dos scripits for db2

Internet Services

Web Development

Digital Marketing

Consumer Tech