Here is a sample of one of my batch files.

echo off
cls
del stats.txt
db2cmd /c db2 -f stats.ddl -z stats.txt

The batch file only opens for 1/10 of a second. However, the CLP windows stays up until the query is completed which takes about 5 seconds.

Is there a way of preventing the CLP window from opening (or minimized) and instead run in the background?

Windows 2000 Server / DB2 UDB Version 8.1

Hi,
I use command:
This commands suppreses new window, but still one window is visible. For more info about db2cmd command please see DB2 Command Window Command help

Hope this helps,
Grofaty

use db2clpex.exe instead of db2cmd