How to create batch file to execute multiple DB2 queries

Question

I have to run some DB2 SQL queries more frequently.It is taking lot of time to do that manually. For that, I am planning to create batch file to execute those DB2 SQL commands. So,Please let me know whether it is possible to create windows batch file to run set of DB2 sql queries.

bhamby · Accepted Answer · 2013-07-24 22:01:52Z

8

You can save a .sql file to your hard drive, and execute it using the DB2 command line using:

db2 -vtf C:\path\to\somefile.sql

-v echoes the command text back to the command line

-t sets the statement terminator to ;. If you want to use something else (creating stored procedures for example), you can use -td__ where __ represents up to two characters you can use as the terminator. Alternatively, you can use --#SET TERMINATOR __ inside your batch file

-f tells the command line to load the commands from the file.

See other command line options here.

edited Jul 24, 2013 at 22:01

answered Jul 24, 2013 at 12:45

bhamby

15.6k1 gold badge49 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create batch file to execute multiple DB2 queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related