How to execute more than one sql queries from db2 prompt

ronakmaini · #1 (**permalink**) 10-11-10, 04:59

Hi,

Could anyone plz tell me how to execute mutilpe SQL queries from db2 command prompt.

For example:
select count(*) from sysibm.sysdatatypes
select name from sysibm.sysdatatypes

I tried using semicolon but it failed.

Thanks,
Rons.

nvk@vhv · #2 (**permalink**) 10-11-10, 05:18

Hi,

you have to put the commands in a file and execute it using
db2 -tf <File>
or
db2 -vtf <File>

ronakmaini · #3 (**permalink**) 10-11-10, 06:41

Thanks for the reply.

Apart from using a file, is there any other way to execute these queries from the db2 prompt itself.

Rons.

przytula_guy · #4 (**permalink**) 10-11-10, 07:15

db2 select * from table ; db2 select * from table

dbBash · #5 (**permalink**) 10-12-10, 04:31

Hi,

For running multiple queries from db2 prompt, you can simply run the queries without a semi colon.
eg.
select count(*) from sysibm.sysdatatypes
select name from sysibm.sysdatatypes

there is no need for a semi colon.

Regards
Tini

Internet Services

Web Development

Digital Marketing

Consumer Tech