IBM MAINFRAME HELP & SUPPORT FORUMS

bipinpeter · Joined: 18 Jun 2007 Posts: 47 Location: pune

Hi All,
I've a doubt about the maximum storage in the packed fields.What is the maximum value store in a 3 byte packed field?.I understood that if we assign 3 byte field,if it is packed it will take 6 bytes.Please tell me is it correct or not?
Regards,
Bipin Peter

Sambhaji · Joined: 16 Feb 2007 Posts: 267 Location: Pune, India

maximum storage will be five digits and definition will be PIC S9(5)
for more information see below link
<<http://www.simotime.com/datapk01.htm>>

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St

Hello,

Quote: I understood that if we assign 3 byte field,if it is packed it will take 6 bytes.Please tell me is it correct or not? This is not correct.

A 3-byte field can hold a s999 (zoned decimal) value or an s9(5) comp-3 (packed decimal) value.

I do not understand how a 6-byte reference relates to the max a 3-byte field may contain.

If i'ver misunderstood something, please clarify.

bipinpeter · Joined: 18 Jun 2007 Posts: 47 Location: pune

I mean that can we store 6 digit number in a 3 byte packed filed?if so what is the maximum value i can store in it?

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St

Hello,

(99999+) - S9(5) comp-3 - is the largest packed decimal value that can be stored n 3 bytes.

5 nibbles (1/2 bytes for the digits) and 1 nibble fro the sign (c, d, or f).

bipinpeter · Joined: 18 Jun 2007 Posts: 47 Location: pune

Actually my problem is that,in quikjob report ,i given ACCUM size is 3 byte,after 125532 records it abended with because of overflow.So i want to know that what should be the maximum value we can store in the 3 byte packed filed.

dbzTHEdinosauer · Joined: 20 Oct 2006 Posts: 1639 Location: germany

one of the other sites has an ICON of someone banging themselves on the head with a hammer - trying to understand the OP's question - or conversely, suggesting that the OP is a little thick-headed.

But in this case, it could be that the OP just does not understand diddly squat because he has not bothered to read any documentation.

Even though I consider it poor form to give links to non-IBM documents to explain very basic concepts, the link provided by Sambhaji had enough pictures, even a non-english speaker could understand the concept.

Since the OP obviously only wants a simple answer and does not want to invest anytime whatsoever trying to answer his/her own question:

a 3 byte Packed-Decimal field will hold 99,999 with or without sign.

i think I need to change my avatar, again.

Anuj D. · Joined: 22 Apr 2006 Posts: 2229 Location: Phoenix, AZ

dbzTHEdinosauer wrote: i think I need to change my avatar, again. Gladiators also need rest at times..so .. :) ..

By the way do you know, "avatar" is an Indian word, I mean this is taken from a native language of here..

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St

Hello,

Quote: So i want to know that what should be the maximum value we can store in the 3 byte packed filed. There is a difference between persistent and simply stubborn. . .

You have been told multiple times the maximum value that will "fit" into a 3-byte packed-decimal/comp-3 field is 99999(+ or -). That answer is not going to change. . .

Quote: i given ACCUM size is 3 byte,after 125532 records it abended ... Why do you believe this is a packed-decimal field?

What have you learned from the quickjob documentation? Have you looked at the quickjob documentation? Have you tried using a larger accumulator? What happened?