Thanks for this. I set all the internal vars as DOUBLE PRECISION and that cracked it

Thanks again
Jem Rayfield



Ales Kahanek
<ales.kahanek@nba To: "'ib-support@yahoogroups.com'" <ib-support@yahoogroups.com>
s.cz> cc:
Subject: RE: [ib-support] stored proc calc prob
25/09/2002 15:11
Please respond to
ib-support






try
:X = ( (CAST( :USER_COUNT AS FLOAT) / :TOTAL_USERS ) * 100);

Ales

> -----Original Message-----
> From: Jem Rayfield [mailto:jem.rayfield@...]
> Sent: Wednesday, September 25, 2002 4:04 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] stored proc calc prob
>
>
>
> 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.
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> 4 DVDs Free +s&p Join Now
> http://us.click.yahoo.com/pt6YBB/NXiEAA/MVfIAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> 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.