DB2 Command Center

[Hattusas]

I have DB2 database 7.1.0 with fix pack 11;that is to say I have 7.2.8 version on Windows Platform.
However I have problems in my command center;I can't run my multiple queries sequentially when the queries are ended by ";".I select the use termination character ";" but this performs single query at a time.I have to erase the query and resubmit the rest again.So it takes very long time when I run queries obtained by "generate dll" action.
When I remove this option,the processor takes a query in a single line for example
create table
schema1.table1(
field1 varchar(80) not null) are considered as 3 queries.

How can I solve this problem?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr

 

[blom0344]

I cannot reproduce your problem, but there are MUCH better tools than command center for DB2.

A nice trial version can be found here:

http://www.cardett.co.nz

(Advanced Query Tool; originally specially for DB2)

It will give a nice logging screen dump to verify the results.....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[dja1]

Hattusas - I assume you're using the "Interactive" option in Command Centre - try doing the same thing in the "Script" option.