Displaying a PIC s9(7) field

kodeesm · New User Joined: 21 Jun 2006 Posts: 5 Location: Pune

Hi,
When I am trying to display a PIC s9(7) field, in the SYSOUT it is coming up with 000000{. This field is getting update into the database, In the database it is showing as 972.

Kodeeswaran.

Terry Heinze · Posted: Thu Jan 08, 2009 9:55 pm

A decimal value of +0 would display as 000000{ as you've shown. X'F0F0F0F0F0F0C0'. I have no idea where the 972 is coming from. Are you looking at the correct row? column?.

dick scherrer · Posted: Thu Jan 08, 2009 10:43 pm

Hello,

kodeesm · New User Joined: 21 Jun 2006 Posts: 5 Location: Pune

Thanks for your valuable info. We are mapping the variables right now to ensure we are on the correct side.

nitesh.mulay · New User Joined: 30 May 2006 Posts: 10 Location: Pune

you can try with using s9(7) sign leading separate clause

dick scherrer · Posted: Fri Jan 09, 2009 10:19 am

Hello,

How will that help with a value of zero in the display output when the database shows 972?

shak_pm · New User Joined: 09 Jan 2009 Posts: 1 Location: chennai

Hi ,

I think the value here is 000000{ . the symbol '{ ' is representing a +ve zero for a signed field.But it is displayed as 972 ,so the possibility may the field is getting mapped somewhere before going to databse or please check if the correct row or column value is being checked.

to get the exact value in sysout we can move the field s9(7) value to a editing picture clause and then display.