It's not the operator -
what the message is telling you is that "bytes" is a decimal number, not
a character field.
So you need to write the zero as a number, not a 'char'
select * from summary where bytes <> 0
The best ref I found is the TSM Version 5.1 Technical Guide Redbook,
Appendix A.
Go to www.redbooks.ibm.com, search on SG24-6554, download the PDF.
VERY helpful.
Wanda Prather
"I/O, I/O, It's all about I/O" -(me)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Debbie Bassler
Sent: Tuesday, August 23, 2005 2:01 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Query for Summary Table
I'm trying to query the summary table, but, I don't want any information
for schedules with 0 bytes. I've tried <>, !=, and ^=. None of these
work.
This is the error I receive:
ANR2916E The SQL data types DECIMAL(18,0) and CHAR(1) are incompatible
for
operator '<>'.
|
..................................V.....
select * from summary where bytes <> '0'
Does anyone know what operator I need to use? Also, any idea where can I
find information on querying database tables?
Thanks in advance,,,,
Debbie
|