tag:blogger.com,1999:blog-18371456.post7392796155330232562..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: New Data Types [DB2 9 for z/OS]Craig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-18371456.post-43125376753933021402007-10-03T04:28:00.000-05:002007-10-03T04:28:00.000-05:00Any idea how the DCLGEN will look like using this ...Any idea how the DCLGEN will look like using this new data-types?<BR/><BR/>As far as I know COBOL does not support such enormous numeric formats. <BR/><BR/>Does this main that you must constantly CAST in your embedded SQL?<BR/><BR/>b.t.w. Someware else I read that the new power6 also supports that format, so using DECFLOAT on Viper on AIX is also adviced.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18371456.post-49364451889603643272007-09-27T12:10:00.000-05:002007-09-27T12:10:00.000-05:00Well, BIGINT would be useful for someone who wante...Well, BIGINT would be useful for someone who wanted to store integers greater than 2.1 billion (or so) within 8 bytes of storage. <BR/><BR/>For a DECIMAL(m,n) column the amount of storage required is: (m/2)+1 bytes. So, for m = 15 or more there is a range of values where BIGINT can take up less storage.Craig S. Mullinshttps://www.blogger.com/profile/17077237739217901780noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-9661332569983242282007-09-26T15:40:00.000-05:002007-09-26T15:40:00.000-05:00Can you please provide additional information on w...Can you please provide additional information on why someone would want to use BigInt when they can use BigDecimal for better precision?<BR/><BR/>Is there a performance gain for using BigInt? How?<BR/><BR/>Thank you.Anonymousnoreply@blogger.com