A moot point from me, as Richard has settled the DB type question but,

You should still be able to execute system 'dsmadmc' commands and
collect the output into perl? IE, using the backticks notation or
system() or something similar to just do 

@output=`dsmadmc -id= -pa= select stuff from the_db where thingummies
are interesting`

or similar....

no?



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Hans Christian Riksheim
Sent: Wednesday, October 13, 2004 12:49 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Equivalent of UNIX "tail/head" in TSM SQL query

 

> 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.


Usually Perl is what I use on all platforms, but in this case it is not
possible. This because the SQL is made within TSM Console which gives no
such options.


Best regards

Hans Chr. Riksheim 


___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be read by 
those to whom they are addressed. If you are not the intended recipient, please 
contact us, delete the message from your computer and destroy any copies. Any 
distribution or copying without our prior permission is prohibited.

Internet communications are not always secure and therefore Powergen Retail 
Limited does not accept legal responsibility for this message. The recipient is 
responsible for verifying its authenticity before acting on the contents. Any 
views or opinions presented are solely those of the author and do not 
necessarily represent those of Powergen Retail Limited. 

Registered addresses:

Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 
8LG.
Registered in England and Wales No: 3407430

Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432