ADSM-L

Query for Summary Table

2005-08-23 14:01:58
Subject: Query for Summary Table
From: Debbie Bassler <Deborah_Bassler AT PAPAJOHNS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 23 Aug 2005 14:00:39 -0400
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

<Prev in Thread] Current Thread [Next in Thread>