Hello all, (I've searched the list archive and the server readme's to see if this a known problem but I can't find anything)
Does anybody understand why the second select doesn't find the node BLAAT2 ? I must be missing something, but I've been staring at this for quite some time and I can't see what I'm doing wrong. tsm: XXXXXX>select node_name,contact from nodes where node_name like 'BLAAT%' NODE_NAME CONTACT ------------------ ------------------ BLAAT1 Alexander BLAAT2 tsm: XXXXXX>select node_name,contact from nodes where node_name like 'BLAAT%' \ cont> and contact not like 'Alex%' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. Regards, Alexander ------------------------------------------------------------ Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services
