It looks to me like the quoting is at issue. With a mixture of double and
single quotes in the SELECT statement itself, it gets tricky when you have
to surround the command with another set of quotes to satisfy the DEFINE
SCRIPT syntax.
In this situation, use two pairs of double quotes instead of
respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
When Defining Script ...
Hello,
Yesterday Guillaume Gilbert posted some very nice select statements. Of
course I am always looking out for cool statements. BTW thx for that.
As I found it worthy.. I deci
Use the web interface, much easier for defining/updating scripts with long
lines and multiple commands - just cut&paste the text.
Tom Michaud
IBM Global Services
"ADSM: Dist Stor Manager" wrote on 01/27/2005
02:51:48 PM:
> Hello,
>
> Yesterday Guillaume Gilbert posted some very nice select
Hello,
Yesterday Guillaume Gilbert posted some very nice select statements. Of
course I am always looking out for cool statements. BTW thx for that.
As I found it worthy.. I decided to added it to the TSM server.
define script sessioninfo "select cast(session_id as decimal(7,0)) as
"Session", c
