MVSFORUMS.com

jayram99 · Posted: Wed May 31, 2006 1:13 pm Post subject: COMP-3 maximum storage

Hi,

I have defined a field AMT-TRAN S9(6)V9(2) comp-3. It is having value of
3742966.00 .

What is the maximum value can be stored in S9(6)V9(2) comp-3 ?

When that value(3742966.00) is inserted into a DB2 Table for a column defined as DECIMAL(6,2). I am getting errror with the data is truncating.

When i define S9(6)V9(2) comp-3 , what is the corresponing data type and size in DB2 Table.

Please suggest me .

Thanks & Regards,
jayaram

kolusu · Posted: Wed May 31, 2006 1:51 pm Post subject:

jayram99,

You need to get your basics right. In Cobol for a comp-3 packed field specifies the number of digits after unpacking. The actual number of bytes occupied in the file is about half that. To calculate the number of bytes from the PIC, add 1 (for the sign) to the total number of digits, divide by 2, and round up if necessary. For example:

jayram99 · Posted: Thu Jun 01, 2006 8:14 am Post subject: COMP-3

Kolusu,

Sorry, there was typo error in the earlier mail.

I have defined AMT-TRN as S9(6)V9(2) COMP-3 in cobol program. For DB2 the column is defined as DEC(8,2). which satisfies as per below condition.

DECIMAL(p,s) = PIC S9(p-s)V9(s) COMP-3

We can view data in AMT-TRN as 3742966.00 but while loading into table, the job is failing for data truncation.

S9(6)V9(2) is 5 bytes and stores 3742966.00 value.
DEC(8,2) is 5 bytes and could not store the same value.

Pls. let me know if i am missing something.

Jayaram

kolusu · Posted: Thu Jun 01, 2006 8:25 am Post subject:

jayram99 · Posted: Thu Jun 01, 2006 9:06 am Post subject: COMP-3

Thanks Kolusu.

The DATA is coming from source and we could see the data with FILE-AID.

This is a Data Qualtiy Issue. I will put forward the same to Business Team.

jayaram

NASCAR9 · Posted: Thu Jun 01, 2006 9:38 am Post subject:

kolusu,

kolusu · Posted: Thu Jun 01, 2006 9:44 am Post subject:

NASCAR9,

I made a mistake in the declaration. I showed s9(5) but in when adding I used 6 which is wrong. I corrected it now. Thanks for bringing it to my attention.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

CraigG · Posted: Wed May 21, 2008 9:01 am Post subject: Re: COMP-3

slade · Posted: Wed May 21, 2008 3:10 pm Post subject:

I think you can "store" 3742966.00 into a S9(6)V9(2) COMP-3 field if is's part of a group move, but it will get truncated when refed as an elementary item.

Why doesn't th OP change the declaration to S9(7)V9(2)/DEC(9,2)? that should solve the problem.
_________________
Regards, Jack.

"A problem well stated is a problem half solved" -- Charles F. Kettering

CraigG · Posted: Wed May 21, 2008 8:21 pm Post subject: