Antwort: Re: SQL-Backtrack and multiple tapes

2001-02-04 Thread Rolf Meyer
Hello Steffan, client has max mount point of three, which is more as he needs. Is collocating no the right choice ? Greetings Rolf Meyer arhoads <[EMAIL PROTECTED]> am 02.02.2001 18:01:31 Bitte antworten an [EMAIL PROTECTED] An:[EMAIL PROTECTED] Kopie: (Blindkopie: Rolf Meyer/Sa

Re: Fresh implementation of TSM

2001-02-04 Thread Alyn Bush
looks like nobody likes to answer simple and silly questions, I thought no question is stupid. Once again any idea of MS Mail Exchange Agent for TSM, where to get more info. and how to start...etc. Also deciding to upgrade from ADSM Server for AIX-RS/6000 - Version 3, Release 1, Level 2.40 to la

Re: SQL Help

2001-02-04 Thread Suad Musovich
> UPDATE SCRIPT Q_NODE_OCCUPANCY4 ' (select distinct count(volume_name) from >volumeusage where occupancy.node_name = volumeusage.node_name) as NUMBER_OF_TAPES -' Haven't figured it out yet, but your sub-query is incorrect. You want; select count(distinct volume_name) from Cheers, Su

SQL Help

2001-02-04 Thread Andrew Webster
Hi All, Are there any SQL gurus you can help me out here? I'm trying to write a script that prints NODE_NAME, TOTAL_GIGABYTES, NUMBER_OF_FILES and TOTAL_TAPES all in one line. Here is what I have so far:- UPDATE SCRIPT Q_NODE_OCCUPANCY4 'select -' UPDATE SCRIPT Q_NODE_OCCUPANCY

Re: DSMADMC SQL SELECT on Windows and SQLDISPLAYMODE

2001-02-04 Thread arhoads
John, I use -commadelimited... Steffan "Talafous, John G." wrote: > > Greetings, > I run the TSM Administrative Command line interface on Windows. I use > batch/command files to perform a number of functions. I could use some help > in formatting the output of the SQL SELECT statement. > In