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
