ADSM-L

Re: Question about using global characters in a select statement

2002-07-24 11:17:54
Subject: Re: Question about using global characters in a select statement
From: "Bratlie, Allen" <Al.Bratlie AT WESTGROUP DOT COM>
Date: Wed, 24 Jul 2002 10:16:05 -0500
I ran into this same problem a while back. If you are using the command with
a script, you need to use '%%string%%'. If you type them into the admin
interface you should be able to use '%string%'.

I run several scripts from a W2K batch file similar to this:

DSMADMC.exe -tcpserveraddress=tsmserver -tcpport=1500 -id=user
-password=password -COMMAdelimited -outfile=testdata.csv select node_name,
domain_name from nodes where node_name like '%%DB%%'
domain_name from nodes where node_name like '%%DB%%'