How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes.

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


Please Help Members By Posting Answers For Below Questions

Explain about open switch business continuity software?

835


What are catalog tables in db2?

793


What is explain in db2?

786


What is cloudant database?

848


What is meant by explain?

860


How to find the number of rows in a db2 table?

858


How to create backup table in db2?

859


How do I create a view in db2?

797


What is reorg?

847


How do I start db2 in windows?

808


What do you mean by storage group (stogroup)?

773


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11383


Is schema the same as database?

838


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

857


How to retrieve rows from a db2 table in embedded sql?

1002