Hi, I am trying to make some useful reports by queryring the TSM database, but I can not find out how to fetch the first N rows in that query. In the DB2-manuals I find the "fetch" command, but it does not seem to work here. Also tried googling and searching the archives here. Example where I only want the first 20 results: select filespaces.node_name as "NODE", filespaces.filespace_name as "FILESYSTEM_NAME", substr(char(filespaces.backup_end), 1, 10) as "LAST_BACKUP" from filespaces order by 3 asc fetch first 20 rows only
I am using Tivoli Storage Manager version 5, Release 1, Level 7.3 Thanks, Hans Chr. Riksheim