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
- 73317 Views
- TCS, I also Faced
- E-Mail Answers
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
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the latest version of ibm db2?
Explain in detail about buffer manager and its functionalities?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is explain in db2?
Which components manage deadlocks in db2?
What are the benefits of using the db2 database?
How can we read records for specific member in CL? AND rpg?
Explain about rct in db2?
what is utility for parm lib
How to access db2 tables in mainframe?
Who uses db2?
What happens in bind step in a db2 program?
What is catalog database in db2?
What are the bind parameters ibm db2?
