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:[EMAIL PROTECTED] On Behalf Of Debbie Bassler Sent: Tuesday, August 23, 2005 2:01 PM To: [email protected] 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
