Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
Auryn

New User

Joined: 11 Jan 2006
Posts: 66
Location: Lower Saxony (DE)

 Posted: Mon Jan 28, 2013 5:24 pm    Post subject: generated Identity-PK: BIGINT or DECIMAL(18) The tables for which I am responsible are defined with a generated identity-pk and most of them in Decimal(18) format. What would you recommend, is better to use? I suppose BigInt is similar to COBOL-Binary and Decimal is similar to COBOL-Display? Than I guess BigInt requires much less storage space in table- and in indexspace as well. Furthermore, I suspect that it's faster to compute new BigInt- than Decimal identities - similar to COBOL - because decimal values need to be converted in binary format. Am I right? Do you agree with that? Thanks a lot for your help

Bill Woodger

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7312

 Posted: Mon Jan 28, 2013 5:35 pm    Post subject: Reply to: generated Identity-PK: BIGINT or DECIMAL(18) You need to know whether DECIMAL would be "internal" (packed) or "external" (zoned). Why do you believe that Cobol would change decimals to binary to do arithmetic? There are specific decimal-arithmetic machine instructions. An 18-digit binary is enormously far from "faster" compared to an 18-digit packed-decimal, which I'd avoid using anyway, if possible, as 17 digits are "faster".
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics To convert numeric to Packed Decimal vinu78 DFSORT/ICETOOL 8 Fri Jul 31, 2020 7:14 pm Convert a packed decimal value to zon... Dinesh Mani DB2 6 Mon Mar 16, 2020 6:02 pm Identifying Packed Decimal data in a ... sojivarkey TSO/ISPF 4 Sat Dec 07, 2019 5:36 am Reading the CSV data in COBOL and mov... wik123 COBOL Programming 4 Tue Dec 03, 2019 5:13 pm Convert Numeric to Packed decimal and... anand1204 DFSORT/ICETOOL 5 Thu Aug 08, 2019 3:53 am

 © 2003-2020 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us