Hi,

Here is my query and it's result.

db2 => SELECT CHAN_NAME, COUNT(LOGON_ID) FROM DB2A.HDRLOG LOG, DB2A.CHANNEL CHN WHERE LOG.TSTAMP BETWEEN '2004-03-25-00.00.00' AND '2004-04-03-23.59.59' AND LOG.CHANNELID = CHN.CHANNELID GROUP BY CHAN_NAME

CHAN_NAME 2
----------- -----------
46093
BA 29860
CC 18
OLB 9450
WAS 37


what do i need to do if I want result as given below.
Basically i want eliminate the row which has CHANNELNAME is null
CHAN_NAME 2
----------- -----------
BA 29860
CC 18
OLB 9450
WAS 37

I appreciate ur help!

Thanks

Try:

SELECT CHAN_NAME, COUNT(LOGON_ID) FROM DB2A.HDRLOG LOG, DB2A.CHANNEL CHN WHERE LOG.TSTAMP BETWEEN '2004-03-25-00.00.00' AND '2004-04-03-23.59.59' AND LOG.CHANNELID = CHN.CHANNELID and channelname is not null
GROUP BY CHAN_NAME


Andy

Hi

Try this:

SELECT CHAN_NAME, COUNT(LOGON_ID) FROM DB2A.HDRLOG LOG, DB2A.CHANNEL CHN WHERE LOG.TSTAMP BETWEEN '2004-03-25-00.00.00' AND '2004-04-03-23.59.59' AND LOG.CHANNELID = CHN.CHANNELID AND LOG.CHAN_NAME IS NOT NULL GROUP BY CHAN_NAME

BOW

Hi,

it did not work in my case. I guess CHANNELNAME is not null . I guess it could have blank space. If that is the case what i suppose to do?

You could try:

rtrim(channelname) <> ''

Andy

yes Andy it worked

thanks