Interested to Buy Any Domain ? << Click Here >> for more details...
How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes.
- 7 Answers
- 73305 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vikram and mangesh
The null value is the concept of DB2 and your application
program does not understand the null concept, so to handle
the null value in our application program we use null
indicator.
Null indicator will have following values(depending upon
what values comes from DB2).
0 means the column is not null and any actual value stored
in the column is valid.
-1 means column is set to null.
-2 means column was set to null as the result of a data
conversion error.
in above scenarion if your table contains nullable columns
(means the column can have null values) and in aplication
program you dont mentioned the null indicator,you will get
sql code -305.
For a NOT NULL column there is no need of null indicator as
there cannot be null at any point of time and if you dont
give any value then you will get SQL code -407.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Explain the contents that are a part of dclgen.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is isolation level in db2?
What does a deadlock mean in DB2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the physical storage length of timestamp data type?
How to check last update on table in db2?
What is the max length of sqlca?
What is the purpose of rollback and commit?
What is load replace in db2?
B37 abend during spufi?
List out the three types of page locks that can be held.
Is it possible using max on a char column?
What is dbrm? When it will be created?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
