I sent all the apar on this....did no one get it?
I was the originator of this apar....months ago...
?
tw

-----Original Message-----
From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
Sent: Thursday, September 19, 2002 7:21 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 4.2.x selects from DRIVE table


Yes, I have seen this, but I forgot to open a PMR on it.  I guess I need to.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: David Stabler [mailto:dstabler AT MORRISONHOMES DOT COM]
Sent: Thursday, September 19, 2002 9:26 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bug....it's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.....  WEIRD.....

-drs-

>>> xjolliff AT TI DOT COM 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?