| View previous topic :: View next topic |
| Author |
Message |
mainhead
Beginner
Joined: 07 Feb 2006
Posts: 26
Topics: 11
|
 Posted: Thu Aug 03, 2006 8:09 pm Post subject: Sqlcode +304 |
 |
|
HI ,
We are using Ims Dc front end with DB2 has back end . Our online screen abends when user makes some operation. When i analysed it comes out with Return code +304 . Could you please let me know how to overcome this error .
| Code: |
DSNT404I SQLCODE = 304, WARNING: A VALUE WITH DATA TYPE DECIMAL CANNOT
BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN
THE RANGE OF THE HOST VARIABLE IN POSITION 001 WITH DATA TYPE
DECIMAL
|
Thanks in advance . |
|
| Back to top |
|
 |
shekar123
Advanced
Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
|
| Posted: Thu Aug 03, 2006 8:27 pm Post subject: |
|
|
Mainhead,
Make use of the info and try to debug.Hope this helps.
| Code: |
+304
A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS
NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION position-number WITH DATA TYPE data-type2
Explanation: A FETCH or SELECT into a host variable list or structure, position number position-number failed because the host variable having data type data-type2 was not large enough to hold the retrieved value having data type data-type1.
System Action: The FETCH or SELECT could not return the data for the indicated SELECT item, the indicator variable is set to negative two (-2) to indicate a null value returned. Processing continues.
Programmer Response: Verify that table definitions are current, and that the host variable has the proper data type. See the explanation for SQLCODE -405 for ranges of SQL data types.
SQLSTATE: 01515
-405
THE NUMERIC LITERAL literal CANNOT BE USED AS SPECIFIED BECAUSE IT IS OUT OF RANGE
Explanation: The specified numeric literal is not in the proper range.
The proper ranges for SQL values are as follows:
v 5.4E−79 to 7.2E+75 for FLOAT values
v −(1031 -1) to +(1031 -1) for DECIMAL values
v −2147483648 to 2147483647 for INTEGER values
v −32768 to +32767 for small integer (SMALLINT) values.
System Action: The statement cannot be executed.
Programmer Response: The value of the literal should be reduced to the appropriate size for this data type.
SQLSTATE: 42820
|
_________________
Shekar
Grow Technically |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Aug 03, 2006 8:49 pm Post subject: |
|
|
mainhead,
Check to see if there is mismatch of column attributes to host variables. Make sure the no: host variables are equal to the no: of columns you are selecting.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
mainhead
Beginner
Joined: 07 Feb 2006
Posts: 26
Topics: 11
|
| Posted: Sat Aug 05, 2006 9:25 pm Post subject: |
|
|
| Thanks Kolusu i will try . But i believe the retrieved field not able to occupy the space of the Host field . I will Test and let you know on this . |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
