Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

When do we get a -406 abbend error ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Thu Dec 21, 2006 2:06 pm    Post subject: When do we get a -406 abbend error ?
Reply with quote

When do we get a -406 abbend error? I think it is when there is a overflow in the table of a db2. Can neone pls explain me when we we have a overflow?Is it related to the PIC clause of variable while inserting data into tables?
Back to top
View user's profile Send private message

poul_motiram
Currently Banned

New User


Joined: 05 Dec 2006
Posts: 13
Location: chennai

PostPosted: Thu Dec 21, 2006 2:35 pm    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

Hi,

Errot -406 get when there is a data overflow occurs.
i.e. exceding the size of integer variable.
suppose SAL is declared as INTEGER while creating table.
its maximum size is 32767 & ur trying to store data
larger than its limit then u get -406 error.


Regards,
Motiram
Back to top
View user's profile Send private message
poul_motiram
Currently Banned

New User


Joined: 05 Dec 2006
Posts: 13
Location: chennai

PostPosted: Thu Dec 21, 2006 3:17 pm    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

hi
the max size for a small int column is 32767 and integer 's max value is 2147483647.
so when ever u try inserting a value which has a larger value than these u get a -406 abend code.

hope this satisfies your question.
Back to top
View user's profile Send private message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Fri Dec 22, 2006 11:12 am    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

hey but i still want to clarify something. i have a situation.
a db2 table has a feild declared as integer. but its dcl gen declares the variable for this table with S9(9).
we have an workfeild with the pic as S9(9).

now we update that feild of the table with the value =feild value(s9(9))+workfeild(s9(9)).

here comes the overflow. can u suggest what could be the problem?
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Dec 22, 2006 11:57 am    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

Quote:
now we update that feild of the table with the value =feild value(s9(9))+workfeild(s9(9)).

here comes the overflow. can u suggest what could be the problem?

Adding a 9 digit integer to a 9 digit integer may result in a number having more than 9 digits. Still any doubt on what could be the problem ???
Back to top
View user's profile Send private message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Fri Dec 22, 2006 1:52 pm    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

i am really sorry for the question. I meant i need a solution for the problem. Can u suggest me as to what can be done to avoid this problem?
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Dec 22, 2006 8:39 pm    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

Quote:
Can u suggest me as to what can be done to avoid this problem?

Truncation of added value from fieldvalue and workfield is not suggested, as you may be losing data here; so expanding DCLGEN field should be done instead.
As a functional/data owner of this program/process somebody has to decide on what value they need on the table in such cases, if they insist on having a full value (which is quiet natural) table field size should be increased.
Back to top
View user's profile Send private message
jamir
Warnings : 1

New User


Joined: 04 Dec 2006
Posts: 1
Location: pune

PostPosted: Thu Jan 11, 2007 3:10 pm    Post subject:
Reply with quote

when we get a error code -311

WARNING: START A NEW TOPIC
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Fri Jan 12, 2007 1:49 pm    Post subject: Re: When do we get a -406 abbend error ?
Reply with quote

Hi,

Madhusmita Patnaik wrote:
hey but i still want to clarify something. i have a situation.
a db2 table has a feild declared as integer. but its dcl gen declares the variable for this table with S9(9).
we have an workfeild with the pic as S9(9).

now we update that feild of the table with the value =feild value(s9(9))+workfeild(s9(9)).

here comes the overflow. can u suggest what could be the problem?



You need to define one more column for this as BIGINT

About BIGINT:
It is a 8-byte interger with 19 digits precesion.

But for this you need to contact the DBA and the client BA.

Quote:
Can you give me the values in the two fields.


As my assumption, to your query (First- Atop), I feel it is not with the S9(9) issue, it is the data into that field.
So it is defenetly a data check constraint issue.
Check the DDL for the table.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us