Weird SQL problem flipping signs

I am trying to convert a file with a price array to a flat file.



My new files is defined using DDS as follows:



R PLALTR

ALTSTR 5S 0 TEXT('Store')

ALTSTX 5S 0 TEXT('Store Index')

ALTDPT 4S 0 TEXT('Dept')

ALTCLS 4S 0 TEXT('Class')

ALTVEN 6S 0 TEXT('Vendor')

ALTSTY 7S 0 TEXT('Style')

ALTCLR 4S 0 TEXT('Color')

ALTSIZ 5S 0 TEXT('Size')

ALTALTP 11S 2 TEXT('ALT PLU Price')



K ALTCLS

K ALTVEN

K ALTSTY

K ALTCLR

K ALTSTR



The input file contains the same fields (different names) defined with the
same sizes/types. As previously stated, the ALTALTP is in a 100 bucket
array in the original file.



When I do the following insert



exec sql

insert into aeplaltsiz

values

(

0,

:isugrid * 100 + :index,

0,

:isugCls,

:isugVen,

:isugSty,

:isugClr,

:isugSiz,

:price);



all fields (isugrid, isugcls, isugven, etc.) contain positive values. When
I look at the new file, all of the fields except ALTSTX are negative. I
even inserted a record where isubClr = 0 and DBU shows it a -0. For grins,
I changed one of the values to be isugCls * -1 instead of isugCLS. It
inserted as a positive value.



Anybody have any idea what is going on here? We are at V7.3. I don't know
what PTFs, etc. have been installed.

_____