Changing PF Definition - Signed to Unsigned

Hi All,

 

We have a lot of legacy tables that use signed integers for their field
types.  I would like to convert these fields to an unsigned integer
field.  Now the previous programmers used these fields for storing date
parts (ie: 4S 0 for a year field - why we'd need a negative year is
beyond me, but I digress).  If I do a CHGPF on these fields, will it
affect the data in any way?

 

As I mentioned, we have examples such as this:

PRODYYYY 4S 0

PRODMM    4S 0

PRODDD     4S 0

PRODDATE 8S 0

 

I'd like to change it to this:

PRODYYYY 4  0

PRODMM    4  0

PRODDD     4  0

PRODDATE 8  0

 

What will happen to the data in these tables?

 

Thanks!


Brian.

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

PH: 705-435-7814

FX: 705-435-6746

-=-=-=-=-=-=-=-=-=-=-=-=-=-