Yes. Zoned: 1 digit per byte Packed: 2 digits per byte http://books.google.ca/books?id=elh8ydHWtTYC&pg=PA143
On Nov 16, 1:26 pm, mdipierro <[email protected]> wrote: > are "packed" and "zoned" field types in db2? what is the difference? > > On Nov 16, 11:07 am, DenesL <[email protected]> wrote: > > > It is not a problem. > > I am just recording my observations for future reference. > > > Note 1 says that you can access packed decimal fields with the new > > decimal type (they can also be accessed as double, the driver handles > > the conversion). > > Note 2 says what happens when it creates a new table, decimal fields > > get created as zoned. > > > Denes. > > > On Nov 16, 11:48 am, mdipierro <[email protected]> wrote: > > > > can you explain more. I do not understand. > > > > On Nov 16, 10:34 am, DenesL <[email protected]> wrote: > > > > > DB2/400 also tested OK. > > > > Notes: > > > > 1) Was able to access keyed table with PACKED numeric field as > > > > decimal. > > > > 2) New non-keyed table created decimal fields as ZONED. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
