From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hans Christian Riksheim >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
Install Perl on your (I assume) Windows machine and imbed your select statement within a Perl script that does what you want. Welcome to an operating system that doesn't come with anything resembling a decent scripting language. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
