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
-----------------------------------------------------------------------
=========================================================================
|