[ADSM-L] Antwort: [ADSM-L] Sql query problem in tsm 6.2
2011-09-07 09:38:46
Hi,
use following Syntax:
select ev.node_name, ev.status, no.email_address from events ev, -
nodes no where ev.node_name = no.node_name and -
ev.status != 'Completed' and -
ev.scheduled_start> '2011-09-06 08:00:00' and -
ev.scheduled_start< '2011-09-07 07:00:00'
Thorsten
Von: "Lee, Gary D." <GLEE AT BSU DOT EDU>
An: ADSM-L AT VM.MARIST DOT EDU
Datum: 07.09.11 15:07
Betreff: [ADSM-L] Sql query problem in tsm 6.2
Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
TSM folks,
tsm server 6.2.2 on redhat enterprise linux 6.0
I submit the following file as a macro and recieve the errors below.
This query works in tsm 5.5
file c:\tsmscripts\pl3
-------------
select events.node_name, events.status, nodes.email_address from events, -
nodes where events.node_name = nodes.node_name and -
events.status != 'Completed' and -
events.scheduled_start> '2011-09-06 08:00:00' and -
events.scheduled_start< '2011-09-07 07:00:00'
tsm screen cut below.
----------------
tsm: TSM01>macro c:\tsmscripts\pl3
ANS8000I Server command: 'select events.node_name, events.status,
nodes.email_ ad
dress from events, nodes where events.node_name = nodes.node_name and
events.s ta
tus != 'Completed' and events.scheduled_start> '2011-09-06 08:00:00' and
event s.
scheduled_start< '2011-09-07 07:00:00''
ANR0162W Supplemental database diagnostic information: -1:42S22:-206
([ IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "NODES.NODE_NAME" is not
valid in
the context where it is used. SQLSTATE=42703
).
ANR2940E The command 'select events.node_name , events.status ,
nodes.email_address from events , NODESVIEW where events.node_name =
nodes.node_name and events.status != 'Completed' and
events.scheduled_start >
' 2011-09-06 08:00:00' and events.scheduled_start < '2011-09-07 07:00:00'
'
contains an unknown SQL column name.
ANS8001I Return code 3.
ANS8 29E Macro processing terminated.
tsm: TSM01>
Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310
+++++ 750 Jahre Knappschaft. Soziale Verantwortung zu jeder Zeit.
www.750jahre.info +++++
|
|
|