Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SQL\s+calculation\s+error\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SQL\s+calculation\s+error\s*$/: 3 ]

Total 3 documents matching your query.

1. [ADSM-L] SQL calculation error (score: 1): Author: "Loon, Eric van (ITOPT3) - KLM" <Eric-van.Loon AT KLM DOT COM>; Date: Mon, 23 Jan 2017 14:44:45 +0000; Hi TSM/SP-ers! I have something weird when using te following SQL queries: select sum(fs_used_size),sum(fs_total_size) from sysibmadm.snapstorage_paths Unnamed[1] Unnamed[2] -- -- 74434565120 6920601; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00100.html (11,564 bytes)
2. Re: [ADSM-L] SQL calculation error (score: 1): Author: Sasa Drnjevic <Sasa.Drnjevic AT SRCE DOT HR>; Date: Mon, 23 Jan 2017 15:56:53 +0100; Missing FLOAT statement and greater DECIMAL range? select cast(FLOAT(sum(fs_used_size))*100/sum(fs_total_size)as decimal(4,2)) from sysibmadm.snapstorage_paths Regards, -- Sasa Drnjevic www.srce.uniz; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00101.html (12,534 bytes)
3. Re: [ADSM-L] SQL calculation error (score: 1): Author: "Loon, Eric van (ITOPT3) - KLM" <Eric-van.Loon AT KLM DOT COM>; Date: Mon, 23 Jan 2017 15:58:31 +0000; Hi Sasa! Thank you VERY much for your help! Kind regards, Eric van Loon Air France/KLM Storage Engineering Missing FLOAT statement and greater DECIMAL range? select cast(FLOAT(sum(fs_used_size))*100/; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2017-01/msg00102.html (14,324 bytes)

Current List: 1 - 3
Page: [1]