ADSM-L

[ADSM-L] Basic select help

2016-08-22 20:02:19
Subject: [ADSM-L] Basic select help
From: Shawn Drew <shawndo AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 22 Aug 2016 20:00:08 -0400
I am trying to get a list of nodes that have no filespaces and I am getting 
stuck on what seems to be a very basic select statement.  Can someone tell me 
where I am going wrong?
The way I understand it, the select should at least show the node I just 
created with no filespaces.


tsm: TSM1500>reg n shawntest xxxx do=admin userid=none
ANR2060I Node SHAWNTEST registered in policy domain ADMIN.
 
tsm: TSM1500>select node_name from nodes where node_name NOT IN (select 
distinct(node_name) from filespaces)
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

<Prev in Thread] Current Thread [Next in Thread>