RE: Changing PF Definition - Signed to Unsigned

Great, thanks Jerry.

Brian.

-----Original Message-----
From: Jerry Adams [mailto:jerry@xxxxxxxxxxxxxxx] 
Sent: Tuesday, January 31, 2006 2:01 PM
To: Midrange Systems Technical Discussion
Subject: Re: Changing PF Definition - Signed to Unsigned

Charles is right.  But to answer your original question, Brian, "Will it

affect the data in any way?": Yes and No.

Yes:   It will, as Charles points out, convert it to a packed format. 
such that '2006'  goes from


    FFFF
    2006


to


    006
    20F


No:   It's still '2006'.  (In a 4P 0 definition, the leading '0' is 
ignored.)



        * Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Wilt, Charles wrote:

>Brian,
>
>I think you need to take a look at the DDS manual.
>
>4S 0 doesn't mean 'signed', it means zoned.
>
>4  0 doesn't mean 'unsigned', it means packed (as does 4P 0).
>
>In either case, zoned and packed fields are always signed.
>
>The iSeries doesn't have an "unsigned" type for any files regardless of
>if you use DDS or SQL DDL to define the file.
>
>HTH,
>
>Charles Wilt
>--
>iSeries Systems Administrator / Developer
>Mitsubishi Electric Automotive America
>ph: 513-573-4343
>fax: 513-398-1121
>  
>
>  
>
>>-----Original Message-----
>>From: midrange-l-bounces@xxxxxxxxxxxx 
>>[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Brian Piotrowski
>>Sent: Tuesday, January 31, 2006 12:21 PM
>>To: Midrange Systems Technical Discussion
>>Subject: 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
>>
>>-=-=-=-=-=-=-=-=-=-=-=-=-=-
>>
>> 
>>
>>-- 
>>This is the Midrange Systems Technical Discussion 
>>(MIDRANGE-L) mailing list
>>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>>To subscribe, unsubscribe, or change list options,
>>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>>Before posting, please take a moment to review the archives
>>at http://archive.midrange.com/midrange-l.
>>
>>
>>    
>>
>
>  
>