Re: How to prevent leading spaces in SQL output

Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Harris, Steven Sent: donderdag 26 januari 2017 22:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: How to prevent leading spaces in SQL output Hi Eric There are also the STRIP and TRIM

Re: How to prevent leading spaces in SQL output

11:53 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to prevent leading spaces in SQL output Hi Martin! Again, thank you very much for your help! Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L

Re: How to prevent leading spaces in SQL output

Subject: Re: How to prevent leading spaces in SQL output Hi Eric, '-tab' does the magic: [~]$ dsmadmc -tab -se=TSM -id=admin -pa=admin -dataonly=yes "SELECT CAST (float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2)) FROM log" 0.98 [~]$ dsmadmc -se=TSM -id=admin -pa=admin -

Re: How to prevent leading spaces in SQL output

On 25.1.2017. 10:01, Loon, Eric van (ITOPT3) - KLM wrote: > Hi TSM-ers! > I'm executing the following command in a script: > > /usr/bin/dsmadmc -se=$INSTANCE -id=$ID -password=$PASSWORD -dataonly=yes > "SELECT CAST(float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2)) FROM > log" > > The resul

Re: How to prevent leading spaces in SQL output

mb)*100/total_space_mb AS DECIMAL(4,2)) FROM log" 0.98 Bye Martin Janosik "ADSM: Dist Stor Manager" wrote on 01/25/2017 10:01:51 AM: > From: "Loon, Eric van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 01/25/2017 10:06 AM > Subject: [ADSM-L] How to pr

How to prevent leading spaces in SQL output

Hi TSM-ers! I'm executing the following command in a script: /usr/bin/dsmadmc -se=$INSTANCE -id=$ID -password=$PASSWORD -dataonly=yes "SELECT CAST(float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2)) FROM log" The result is this (without quotes): ' 0.49' I'm looking for a way to remov

Re: Weird SQL output

ARIST.EDU] On Behalf Of Efim Sent: vrijdag 21 november 2014 17:41 To: ADSM-L@VM.MARIST.EDU Subject: Re: Weird SQL output Erik, I can't believe that you're never checkin private tapes. After checked in last_use is NULL. It is not an issue. It just tell that nobody use this tape after it

Re: Weird SQL output

es contain the backupset volumes. > Kind regards, > Eric van Loon > AF/KLM Storage Engineering > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Efim > Sent: vrijdag 21 november 2014 13:41 > To: ADSM-L@VM.MARIST.EDU >

Fw: Weird SQL output

%20Storage%20Manager - Forwarded by Andrew Raibeck/Hartford/IBM on 2014-11-21 08:13 - Andrew Raibeck/Hartford/IBM wrote on 2014-11-21 08:12:33: > From: Andrew Raibeck/Hartford/IBM > To: "ADSM: Dist Stor Manager" > Date: 2014-11-21 08:12 > Subject: Re: Weird SQL o

Re: Weird SQL output

kis/home/wiki/Tivoli%20Storage%20Manager "ADSM: Dist Stor Manager" wrote on 2014-11-21 08:02:09: > From: "Loon, EJ van (ITOPT3) - KLM" > To: ADSM-L@VM.MARIST.EDU > Date: 2014-11-21 08:03 > Subject: Re: Weird SQL output > Sent by: "ADSM: Dist Stor Manager&q

Re: Weird SQL output

Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Efim Sent: vrijdag 21 november 2014 13:41 To: ADSM-L@VM.MARIST.EDU Subject: Re: Weird SQL output Hi, Select with last_use = ‘Data’ is not correct. If you checkout and wh

Re: Weird SQL output

Hi, Select with last_use = ‘Data’ is not correct. If you checkout and when checkin tapes the parameter last_use can be lost. If you want to check private tapes without the data, try to use select like this: select volume_name from libvolumes where status='Private' and last_use is NULL and volume_n

Weird SQL output

Hi guys! I have some weird output from one of my SQL statements. Here it's is: select count(*) from libvolumes where status='Private' Unnamed[1] 3698 Ok, so 3698 private volumes on this server. Now, how many contain data: select count(*) from libvolumes where status='Priva

Re: SQL output format

On Thu, 26 Jun 2003 16:54:38 +0200 Geert De Pecker <[EMAIL PROTECTED]> wrote: > Hi, > > I couldn't find a command for outputting the result of an SQL > as a delimited file, e.g. pipe characters between the fields. > This should allow an external formatter program to be used. > > Geert > >

Re: SQL output format

or dsmadmc -tabdelimited -outfile >>> [EMAIL PROTECTED] 06/26/03 11:06AM >>> dsmadmc -comma ? is what you'r looking for? > -Oorspronkelijk bericht- > Van: Geert De Pecker [mailto:[EMAIL PROTECTED] > Verzonden: donderdag 26 juni 2003 16:55 > Aan: [EMAIL

Re: SQL output format

dsmadmc -comma ? is what you'r looking for? > -Oorspronkelijk bericht- > Van: Geert De Pecker [mailto:[EMAIL PROTECTED] > Verzonden: donderdag 26 juni 2003 16:55 > Aan: [EMAIL PROTECTED] > Onderwerp: SQL output format > > > Hi, > > I couldn't find a

SQL output format

Hi, I couldn't find a command for outputting the result of an SQL as a delimited file, e.g. pipe characters between the fields. This should allow an external formatter program to be used. Geert Geert De Pecker - SOFICO NV Fraterstraat 228-

Re: SQL Output

| grep -v YY > new_filename where XX = the number of rows you want removed from the top where YY = some unique text in the line you want to exclude David E Ehresman To: [EMAIL PROTECTED] Subject

Re: SQL Output

| | cc:

SQL Output

I there a way to get JUST the output from a select statement into a file without the TSM version header info at the beginning and the condition code at the end? This is TSM 4.2 on Aix 5.1. David