Joni - Match your quotes and you'll quickly see what's wrong.
Richard Sims
On Jan 19, 2005, at 12:31 PM, Joni Moyer wrote:
Hi Andy!
You have a very good point of showing my command. Without it is kind of difficult. Here is the exact command that I am entering (I'm just going to use admin admin as id and password and xxxxx as the servername):
dsmadmc -server=xxxxx -id=admin -password=admin -displaymode=table 'select entity as node_name, date(start_time) as date, - cast(activity as varchar(10)) as activity, time(start_time) as start, time(end_time)as end, cast(bytes/1024/1024 as decimal(6,0)) as megabytes, - cast(affected as decimal(7,0)) as files, successful - from summary where date(start_time)> date(current_timestamp - 1 day) - and (entity like 'HM%' or entity like 'PAB%' or entity like 'VMS%' or entity like 'GEOHMKLG%') - and activity='BACKUP' order by successful'
I've just been entering this on the command-line, so I don't have any - within the command. That's when I receive the following:
ksh: 0403-057 Syntax error: `(' is not expected. /home/lidzr8v (chrs144:lidzr8v)
Do I not need the quotes around the select statement? Thank you in advance!
