How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes.
Answer Posted / s
If a column contains nulls and you dont include a null
indicator variable in the program, the program receives a
-305 SQLCODE.
Even if no columns allow for nulls, it may be necessary to
use the null indicator to avoid a -305 SQLCODE. For eg, if
AVG(SAL) is computed and ther eare no employees in the
department, the result is null and a null indicator must be
ccoded on the SQL statement to avoid -305.
EXEC SQL SELECT SNAME
INTO :SNAME:SNAME-INDNULL
FROM S
WHERE SN = :SN-IN
END-EXEC
If SNAME has a value, SNAME-INDNULL contains 0.
If SNAME is NULL, SNAME-INDNULL contains -2.
Similarly, Inserting a NULL also required special handling.
If you are not providing a value for SNAME, a -1 can be
moved to the null indicator associated with the SNAME
column:
MOVE -1 to SNAME-INDNULL
EXEC SQL INSERT INTO S
(SN,SNAME,STATUS,CITY) VALUE
(:SN,:SNAME:SNAME-INDNULL,:STATUS,:CITY)
END-EXEC
Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What is commit in db2?
What is db2 bind?
What is plan in cobol db2?
What is host variable?
What is ibm db2 connect?
What is dbrm? What it contains?
What kind of database is db2?
What is collection in db2 bind?
Explain the contents that are a part of dclgen.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is db2 a mainframe?
What is access path in db2?
How do I optimize a query in db2?
What do you mean by storage group (stogroup)?
Define sqlca.