I am trying to use a select statement to query the events table to get
the node name, start time and status and , then get
  the end time from the filespaces table and pipe them to a file. When I
issue the command it keeps getting an error in
  the output file as follows:

   ANR2904E Unexpected SQL key word token - 'IN'


  The command I issue is as follows from the command line:

adsm> select node_name as "server name",time(actual_start) as "start time",
stat
us from events where domain_name='CRITICAL' or domain_name='STANDARD' and
node_n
ame=nodename in (Select time(backup_end) as "endtime"from filespaces) >>
d:\res
tore\sql2.log
Output of command redirected to file 'D:\RESTORE\SQL2.LOG'
ANS8001I Return code 3.

  Any help would be appreciated

  Mike Anderson
  Michael_Anderson AT hmis DOT org




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.