Windows & DOS: Issues & Discussions

Hi,

I have installed cygwin on my windows XP system. And I am trying to use the following code snippet:

Code:

set SERVER="grep JDBCConnectionPool config.xml | gawk -F; '{print $2}'"
sed -i 's/%SERVER%/WLMDEVDB1/' config.xml

But it doesn't work because at runtime %SERVER% gets replaced by "grep JDBCConnectionPool config.xml | gawk -F; '{print $2}'"

If I try

Code:

SERVER=`grep JDBCConnectionPool config.xml | gawk -F; '{print $2}'`
sed -i 's/$SERVER/WLMDEVDB1/' config.xml

I get 'SERVER' is not recognized as an internal or external command,
operable program or batch file.

I have made sure that

Code:

grep JDBCConnectionPool config.xml | gawk -F; '{print $2}'

gives me what I need, and if I use hardcoded value instead of $SERVER or %SERVER%, sed also works as desired.

Can some one please help? TIA.

In a unix environment you would be using the wrong type of quotes in the sed line. The single quotes stop the substitution of ${SERVER}.

Try:
sed -i "s/${SERVER}/WLMDEVDB1/" config.xml


BUT. The commands need to be in a unix shell script within cygwin environment. You appear to be typing them at a MSDOS command line. The error message "'SERVER' is not recognized as an internal or external command,
operable program or batch file." comes from Windows XP command prompt.

If you want to run only in DOS, not in cygwin, there is a "unix tools for windows". This runs in the DOS prompt, and uses the sematnics of the GNU unix tools - gawk (GNU awk), sed, etc. The binaries are here:

Native Win32 ports of some GNU utilities