Re: Equivalent of UNIX "tail/head" in TSM SQL query
2004-10-13 08:19:14
>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.
...
Hans - The TSM database is not an SQL db. The SQL operations which can
be performed are extremely limited, to what is described in the
TSM Admin Guide and Admin Ref manuals, and the Technical Guide redbook.
And the overhead of some SQL operations can be prohibitive.
In particular, there is no way to limit a table search or its results
set.
Richard Sims http://people.bu.edu/rbs
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Equivalent of UNIX "tail/head" in TSM SQL query, Hans Christian Riksheim
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Stapleton, Mark
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Hans Christian Riksheim
- Re: Equivalent of UNIX "tail/head" in TSM SQL query,
Richard Sims <=
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Hans Christian Riksheim
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Richard Sims
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Richard Sims
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Warren, Matthew (Retail)
- Re: Equivalent of UNIX "tail/head" in TSM SQL query, Hans Christian Riksheim
|
|
|