SQL querying

Wednesday 23 July 2008, Loon, E.J. van - SPLXM wrote:
Hi *SM-ers!
I'm trying to create an SQL query to extract failed files from the
activity log.
When I do a select * from actlog all goes well, but as soon as I replace
the * with things like nodename, date_time, message to filter the
output, the query becomes slower and slower.
Is there a possibility in TSM to put the output of a slightly filtered q
actlog (eg. Select * from actlog where originator='CLIENT') in a
temporary table space which one can use in different queries later on?
It is faster / easier to do a select * from actlog and dump the output to a
file. I prefer perl to process the content of the file.


Stef