Re: Query for Summary Table
2005-08-23 14:15:35
> 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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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 AT VM.MARIST DOT EDU> 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/IBM@IBMUS
> Internet e-mail: storman AT us.ibm DOT com
>
> 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 AT VM.MARIST DOT 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
|
|
|