I am trying the following procedure and getting X = 0 even though
user_count and total_users have values ??

Help what is worng with the expression syntax?

Thanks for ay pointers
Jem.

CREATE PROCEDURE CITY_USER_COUNT
RETURNS
(
CITY VARCHAR(255),
USER_COUNT INTEGER,
X DOUBLE PRECISION,
TOTAL_USERS INTEGER
)
AS
BEGIN
SELECT
COUNT( UID )
FROM
USERS U,
USER_GROUP_INFO UG
WHERE
U.UID = UG.UID
AND
USER_STATE = 'ACTIVE'
INTO
:TOTAL_USERS;
FOR

SELECT
UG.CITY, COUNT( UG.UID ) AS USER_COUNT
FROM
USER_GROUP_INFO UG,
USERS U
WHERE
U.UID = UG.UID
AND
U.USER_STATE = 'ACTIVE'
GROUP BY UG.CITY
ORDER BY UG.CITY
INTO
:CITY, :USER_COUNT

DO
BEGIN
:X = ( ( :USER_COUNT / :TOTAL_USERS ) * 100);
SUSPEND;
END
END


Jem Rayfield
Technical Consultant
Deutsche Bank [/]
CIB - IT Infrastructure
Corporate and Investment Bank (CIB)
London
t: +44(20)754-51943



"Wilson, Fred"
<fred.wilson@bell To: "'ib-support@yahoogroups.com'" <ib-support@yahoogroups.com>
howell.com> cc:
Subject: RE: [ib-support] Upscale the DBMS?
25/09/2002 14:45
Please respond to
ib-support






Terabytes of data ?? Not on a Win platform..

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@...



-----Original Message-----
From: Charles Stanley [mailto:charles@...]
Sent: Tuesday, September 24, 2002 4:12 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Upscale the DBMS?


Is there any comment on this?

At 10:22 AM 09/24/02 -0700, you wrote:

>I'm just concerned about scaling up to
>1000 or so concurrent users and terrabytes of data. I'm sure there is a
>valid reason that people use Oracle, but I'm not sure where the "cut off"
>point may be.
>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/







--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.