
操作DB2數(shù)據(jù)庫的批處理echo輸出結(jié)果不正確
第9行期待結(jié)果:===成功連接到 SAMPLE 數(shù)據(jù)庫[[[實際結(jié)果為: 數(shù)據(jù)庫[[[ 到 SAMPLE第15行期待結(jié)果:===斷開 SAMPLE 數(shù)據(jù)庫連接]]]實際結(jié)果為: 數(shù)據(jù)庫連接]]]1、為什么?2、如何解決?nclick="copycode($('code0'));">復(fù)制代碼
- @echo off
- setlocal EnableDelayedExpansion
- for /f %%d in ('db2 list db directory ^| awk {a[NR]=$0}END{for (j=1;j<=NR;j++) if (a[j]~/間接/) print a[j-4]} ^| awk {print $3}') do (
- db2 connect to %%d >D:monitorfrult.txt
- for /f %%a in ('type D:monitorfrult.txt ^| grep 本地數(shù)據(jù)庫別名 ^| grep %%d ^| wc -l') do (set among=%%a)
- if !among! equ 1 (
- @echo @@d
- @echo ===Inf:DB===
- @echo ===成功連接到 %%d 數(shù)據(jù)庫[[[
- @echo =================================&@echo.
- @echo do my work
- @echo ===Inf:DB===
- @echo ===斷開 %%d 數(shù)據(jù)庫連接]]]
- @db2 connect reset > null
- @echo =================================&@echo.
- @db2 reset MonITOR for db %%d > null
- ) else (
- @echo ===Inf:DB===
- @echo ***%%d 數(shù)據(jù)庫連接失敗!***
- @echo =================================&@echo.
- )
- )
- )

