I did see the decimal field, with a (p,s) of (18,0). However, I didn't realize the quotes were not needed,,,,,,,
I'll also check out the redbook that Wanda suggested,,,, Thanks to all, Debbie Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 08/23/2005 02:11 PM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L@VM.MARIST.EDU cc: Subject: Re: [ADSM-L] Query for Summary Table Debbie, if you examine the attributes of the BYTES column from the COLUMNS table: select * from columns where tabname='SUMMARY' and colname='BYTES' you will see that BYTES is a decimal field. So the single quotes are not necessary, and your syntax should otherwise work. These all do the same thing: select * from summary where bytes != 0 select * from summary where bytes <> 0 select * from summary where not bytes = 0 select * from summary where not bytes == 0 select * from summary where bytes <> 0 Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 2005-08-23 11:00:39: > 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