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
|