Re: Basic SQL debugging

2008-01-28 Thread Huebschman, George J.
Andrew, Thanks. That fixed the issue. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Saturday, January 26, 2008 10:43 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Basic SQL debugging You are on the right track. A couple

Re: Basic SQL debugging

2008-01-26 Thread Andrew Raibeck
You are on the right track. A couple of things to consider: - The values you are operating on are integral values, so you get integral results. In order to get fractional parts, you need to force the math to floating point mode. This can be done by bringing an otherwise ineffective floating point

Basic SQL debugging

2008-01-25 Thread Huebschman, George J.
Time for me to ask a stupid question. I have lots of them... TSM Server 5.4.3 OS is AIX 5.3 I am trying to utilize the Hourly Monitor in Daily Operational Reporting to notify me if I reach 90% of maxscratch. Before I went to the reporting utility, I tried to write a select query. Only pieces of