|
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. >> >> >> >> > > >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
