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
- 72917 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / daphne
Before going to the solution, here is the explanation of a
null indicator.
In DB2, a NULL is stored using a special one-byte null
indicator which is attached to every NULLABLE column. If
the column is defined as NULL, then the indicator field is
used to record this. The indicator variable is transparent
to an end user, but must be provided for when programming
in a host language.
A positive value or a value of 0 means the column is not
null and any actual value stored in the column is valid. A
negative value indicates that the column is set to null. If
the value is -2 then the column was set to null as the
result of a data conversion error. The default is null.
There are two reasons for getting -305.
1) As said in the first answer if the table column is
defined as NOT NULL (with no default) and if we try to
insert a null value we get that.
- This should be resolved by making sure the inserted
value is not null. Null indicator cannot be used here since
the column is defined as NOT NULL.
2) A table column is defined as NULL:
The host variable has a not null value. The Null
indicator is not set in the host program, so the null
indicator is defaulted to a negative value.
- This should be resolved by using a null indicator in
the host program and moving the relevant value to the null
indicator.
| Is This Answer Correct ? | 56 Yes | 5 No |
Post New Answer View All Answers
How does cobol compile db2 program?
What is check constraint in db2?
What is dbrm? What it contains?
what is the responsibility of the construction superintendent
What is the role of data manager in the db2 database?
Can there be more than one cursor open for any program?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is plan in cobol db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the difference between plan and package in db2?
What is a system catalog table in db2?
Explain about rct.
How can we retrieve the total number of records in RPG & CLLE?
Why db2 is called db2?
Is db2 a mainframe?
