Problem in Pro*C

From: Anil K Neela <aneela_at_siue.edu>
Date: Wed, 21 Apr 1999 16:37:30 -0500
Message-ID: <Pine.SO4.4.05.9904211633350.2251-100000@cougar.isg.siue.edu>

Hello,

I am trying to run a little program, where in i try to insert values into a table through pro *c.
The structure of the table is something like this..

Name                            Null?    Type
 ------------------------------- -------- ----
 CARRIER_ID                      NOT NULL NUMBER(2)
 GSAS                            NOT NULL CHAR(19)-------
 FAMILY_DEDUCT                   NOT NULL NUMBER(6,2)
 FAMILY_IND_DEDUCT               NOT NULL NUMBER(6,2)
 ANNUAL_MAX                      NOT NULL NUMBER(8,2)
 LIFETIME_MAX                    NOT NULL NUMBER(10,2)  ------
 COB_FLAG                        NOT NULL CHAR(1)
 LOOKUP_RULES                    NOT NULL NUMBER(1)

It contains a field LIFETIME_MAX number (10,2)

In pro *c, i declared the SQL variables TEMP_LIFETIME_MAX as a double, I am reading the values to be inserted from a file, and for diff recors TEMP_LIFETIME_MAX has values like

100000001/100
100000000/100
100999999/100

and then that value is stored in LIFETIME_MAX field in the table. But when i do a select, the output is like this.

It is displaying 100000000/100 as :00000, instead of 1000000

GSAS                LIFETIME_MAX
------------------- ------------

090536 01 000001 1009999.9
090536 01 000002 1000000.01
090536 01 000003 :00000

Can you tell me why this is happening..

Anil

                                Anil K Neela
                             Ph: (618) 650 4026
                          E-mail: aneela_at_siue.edu
		      URL: http://www.siue.edu/~aneela



*******************************************************************************

Received on Wed Apr 21 1999 - 16:37:30 CDT