Well, well, well!
It's Bart! hehe. How have you been? Outstanding! It worked! hehe.

Thanks for the info!

Have a great Day!







Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Coffman Bart (STL)
[mailto:db2udbdba-ezmlmshield-x10413364.[Email address protected]
Sent: Wednesday, May 31, 2006 11:27 AM
To: LazyDBA Discussion
Subject: RE: DB2CMD (DB2 Version 8.2 for Windows)


Ed,

Try this instead (calling db2cmd with "/c"):

--EDTESTR.bat file
CD\
D:\
CD\DB2
db2cmd /c db2 -tvf EDTESTR.txt
exit

let me know if it doesn't work, as there is a way to do this.

J. Bart Coffman


-----Original Message-----
From: Edwards Ed [mailto:db2udbdba-ezmlmshield- Sent: Wednesday, May 31,
2006 10:15 AM
To: LazyDBA Discussion
Subject: DB2CMD (DB2 Version 8.2 for Windows)

To All,
I have created a script (*.bat) file. When I run this script file
everything works outstanding. However, it does not exit DB2CMD. Does
anyone know how I can make this script exit the DB2CMD and the MS-DOS
command prompts?


--EDTESTR.bat file
CD\
D:\
CD\DB2
db2cmd db2 -tvf EDTESTR.txt
exit



--EDTESTR.txt
CONNECT TO EDTEST;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
******* Confidentiality Notice *******
This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments.





---------------------------------------------------------------------
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