PH733c5 and ORACLE

[Fry, Mark]

Hi Aci,

I'm a bit puzzled by your example.  When you say you have an ORACLE column
defined as CHARACTER(15,6), what exactly do you mean?  I've not come across
that syntax for a CHARACTER item, and I can't find any reference in ORACLE
help to CHARACTER items with both a size and a precision specified. Is this
a typo, and your column is defined as NUMBER(15,6)?

If it is declared as NUMBER(15,6), PowerHouse will treat this by default as
'integer signed size 8' (64 bit signed binary number), and will take care of
the scaling for you.  The fact that the number is being written correctly to
the database indicates that the correct input scale is being applied by
PowerHouse (6 in this instance), so all seems well on the input side of
things.

The output side is a different story, though.  Your example indicates that
PowerHouse is taking the correct value from ORACLE, then somehow transposing
the last 3 digits of the decimal part of the number.  My guess would be it's
something to do with the output scale.  Do you have an element defined in
your PowerHouse dictionary which specifies a new output scale for your
column, perhaps with a new picture?  Just grasping at straws, really.

I tried unsuccessfully to replicate your problem on a machine here, but the
earliest version of PowerHouse I have is 733d3, and it's not an RS6000, and
it's against ORACLE 7.3.3, and it's a Friday, and...

Can you give us more detail on the problem?  Exactly how is the column
defined in ORACLE?  What (if any) element definition exists for the column
in the PowerHouse dictionary?  Has, for example, the column definition been
changed in the database without recompiling the screens/reports in question?

Lots of questions, no real solutions.

Regards,

Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.com

Mark your calendar:
enterprise2000
Cognos User Conference, 
The Hilton London Metropole Hotel, 17-18 October 2000
http://www.cognos.com/uk/enterprise2000

-----Original Message-----
From: Aci Polajnar [mailto:Aci.Polajnar@rcc-irc.si]
Sent: 30 June 2000 06:22
To: 'PowerHouse List'
Subject: PH733c5 and ORACLE

Hi there!

Working with PowerHouse 733c5 on IBM/RISC6000 platform, I get wrong number
display on screen or report if the column from the ORACLE database has more
than 4 decimal places.

For instance

In my database I have Field-1 CHARACTER(15,6). On my Ph screen, if I enter
0,007066, I get 0,007660. Value in database is O.K. but all on screen
calculations, with such a number, are wrong. Anyone familiar with this out
there?

My environment is:

IBM RISC6000 with UNIX 4.1
ORACLE 7.3.4
PowerHouse 7.33c5

Regards!
--
-------------------------------------------------------------
Aci Polajnar                  Tel   : +386(0)63 441144
IS Consultant                 Fax   : +386(0)63 442036
Razvojni Center Celje         e-mail: acip@rcc-irc.si
3000 Celje, Slovenia          URL   : http://www.rcc-irc.si
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.