V3: admdsmc select ...

The next question (may be a silly one):

WHY is CLIENT an unexpected SQL literal token?


Command: dsmadmc -id=? -password=? select node_name as 'CLIENT' from nodes


ADSTAR Distributed Storage Manager
Command Line Administrative Interface - Version 3, Release 1, Level 0.0
(C) Copyright IBM Corporation, 1990, 1997, All Rights Reserved.

Session established with server ADSM: AIX-RS/6000
  Server Version 3, Release 1, Level 0.1
  Server date/time: 11/14/1997 17:24:07  Last access: 11/14/1997 17:20:26

ANS8000I Server command: 'select node_name as CLIENT from nodes'
ANR2906E Unexpected SQL literal token - 'CLIENT'.

                             |
         ....................V................
         select node_name as CLIENT from nodes

ANS8001I Return code 3.

ANS8002I Highest return code was 3.


If I change CLIENT to CLIENTS all works:

ANS8000I Server command: 'select node_name as CLIENTS from nodes'

CLIENTS
------------------
ADSM-OP
ADSM-OP
CLIENT
HD-ADSMTEST



Heinz

-----------------------------------------------------------------------
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Computing Center, University of Karlsruhe
Zirkel 2, P.O.Box 6980
D-76128 Karlsruhe
Germany

phone 0721 - 608 6427                                  fax 0721 - 37550
-----------------------------------------------------------------------
=========================================================================