At 09:29 07.07.98 -0700, you wrote:

Thanx Tom,

your solution works fine.

Hans

>>My 2nd problem is that I'm not able to use wildcard's in the time_date
field:
>>
>>I tried a statement like this:
>>
>>SELECT ACTLOG.DATE_TIME, ACTLOG.MESSAGE, ACTLOG.NODENAME,
>>ACTLOG.SCHEDNAME, ACTLOG.DOMAINNAME FROM ACTLOG WHERE
>>(ACTLOG.NODENAME='DONALD') and (ACTLOG.DATE_TIME like
>>'1998-07-07%')
>>
>>because all I need is information about the node DONALD from only one
day.....
>>
>>Any ideas?
>
>
>I believe you can accomplish what you want by truncating the date
>field (in this case actlog.date_time) to include only the date
>information. E.g.,
>
>SELECT substr(CHAR(actlog.date_time),1,10), actlog.message, \
>       actlog.nodename, actlog.schedname, actlog.dommainname \
>FROM   actlog \
>WHERE  actlog.nodename = 'DONALD' \
>AND    substr(CHAR(actlog.date_time),1,10) = '1998-07-07'
>
> -- Tom
>
>Thomas A. La Porte
>DreamWorks Animation
>tlaporte AT dreamworks DOT com
>
>
***********************************************************************
Hans Pfleger                                            hans AT telecom DOT at
Informations-Technologie Austria GmbH                        iT-AUSTRIA
Betriebsysteme Unix BSU                         Tel. ++43 1 21717/52121
AIX and ADSM Administrator                      FAX: ++43 1 21717/51919
***********************************************************************
        You have just moved your mouse.
        Please reboot to make sure the changes are activated !!!