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
- 73604 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
How to check table size in db2 sap?
What is data manager?
What is declare cursor?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain about dbrm.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is universal database?
What is db2?
What is the latest version of ibm db2?
What is reorg and runstats in db2?
What is buffer pool in the db2 database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is image copy in db2?
List down the data types in the db2 database.
