Hans Christian Riksheim wrote:
>
> I essentially want to "stream" the output of the sql through a filter
> while it is returned from the TSM-server, not glob it up in memory
> first and then process it later. Have not found out yet with DBI. Some
> database guy suggested use of cursors which make it possible to fetch
> one row at a time and have the database keep track of your progress,
> but I don't know the first thing about cursors and I don't think the
> TSM database is designed for those needs anyway.

I haven't used the DBI::TSM module, nor am I a database guy.  But the
TSM implementation of SQL SELECT does support the use of cursors.  I've
seen various tools use them (there's a STORServer tool that uses them,
and I wouldn't be surprised if TSM Operational Reporting used them).

Not being a database guy, though, I couldn't tell you _how_ to use them,
or if DBI::TSM supports the use of them.

--
Hello World.                                    David Bronder - Systems Admin
Segmentation Fault                                     ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bronder AT uiowa 
DOT edu