hi Michael, may be you can look into replacing CALL with START /WAIT.

You can get the full syntax by typing HELP START from any CMD prompt.

Cheers
Ray



"michaelr_41" <db2udbdba-ezmlmshield-x69729974.[Email address protected]
08/29/2005 04:44 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
DB2 in Win2K .cmd file synchronization






Hi folks -

Here's my deal. I need to issue several DB2CMD commands from a Win2K
command file. I need to do some DB2 stuff, copy some files, do more DB2
stuff, wait 10 seconds, then more DB2 stuff. The problem I'm
encountering is that when my command file hits a line such as:

Call C:\PROGRA~1\WebSphere\SQLLIB\BIN\db2cmd /i db2 -t -f
"C:\Load_SQLTxt.txt" -z "C:\logs\upload_batch_log.txt"

It spawns off another window and the command file goes on its merry way,
and everything else executes. I don't want that - I want the command
file to wait until this is completed. However, if I don't call db2cmd,
then after it completes, it ends the DB2 command environment (I
believe), and I need to exit to get back to the command prompt. The
command file stops executing at that point.

This process is automated and invoked from a different system via MQ, so
I don't have a lot of control over it.

How can I approach this problem? Carefully? <smile> TIA!
--

[Email address protected]

--
http://www.fastmail.fm - Does exactly what it says on the tin



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page