Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+How\s+to\s+prevent\s+leading\s+spaces\s+in\s+SQL\s+output\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+How\s+to\s+prevent\s+leading\s+spaces\s+in\s+SQL\s+output\s*$/: 6 ]

Total 6 documents matching your query.

1. [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: "Loon, Eric van (ITOPT3) - KLM" <Eric-van.Loon AT KLM DOT COM>; Date: Wed, 25 Jan 2017 09:01:51 +0000; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00103.html (11,619 bytes)
2. Re: [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: Martin Janosik <martin.janosik AT CZ.IBM DOT COM>; Date: Wed, 25 Jan 2017 11:03:43 +0100; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00104.html (13,814 bytes)
3. Re: [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: Sasa Drnjevic <Sasa.Drnjevic AT SRCE DOT HR>; Date: Wed, 25 Jan 2017 11:03:26 +0100; I don't know the exact way, but either of the following options for dsmadmc will work as a workaround in this case only, where you have only one number as a result: -TABdelimited -COMMAdelimited Rega; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00105.html (12,726 bytes)
4. Re: [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: "Loon, Eric van (ITOPT3) - KLM" <Eric-van.Loon AT KLM DOT COM>; Date: Wed, 25 Jan 2017 12:53:12 +0000; Hi Martin! Again, thank you very much for your help! Kind regards, Eric van Loon Air France/KLM Storage Engineering Hi Eric, '-tab' does the magic: [~]$ dsmadmc -tab -se=TSM -id=admin -pa=admin -data; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00106.html (15,434 bytes)
5. Re: [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: "Harris, Steven" <steven.harris AT BTFINANCIALGROUP DOT COM>; Date: Thu, 26 Jan 2017 21:52:18 +0000; Hi Eric There are also the STRIP and TRIM sql functions - same function for these but slightly different syntax. SELECT strip(cast(float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2))) FROM log H; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00109.html (17,477 bytes)
6. Re: [ADSM-L] How to prevent leading spaces in SQL output (score: 1): Author: "Loon, Eric van (ITOPT3) - KLM" <Eric-van.Loon AT KLM DOT COM>; Date: Fri, 27 Jan 2017 11:59:11 +0000; Hi Steven! Thanks for your reply! As suggested by Martin adding the -tab switch to the dsmadmc does the trick as well as adding the varchar_format function: SELECT varchar_format(CAST(round(float(use; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00110.html (19,464 bytes)

Current List: 1 - 6
Page: [1]