> 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
Before someone catches me out... yes, the last example is an inadvertent duplicate of the second example. :-) 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" <[email protected]> wrote on 2005-08-23 11:11:49: > 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" <[email protected]> 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
