Re: Changing PF Definition - Signed to Unsigned

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

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.
> >
> >
> >    
>
>