Interested to Buy Any Domain ? << Click Here >> for more details...
What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
- 1 Answers
- 7803 Views
- I also Faced
- E-Mail Answers
Answer / amarnadh reddy
Hi,
-305 is Null Indicator is needed. The null value cannot be
assigned to output host variable. Because no Indicator
variable is specified. (to fetch or select operation
resulted in the retrieval of a null value to be inserted
into the output host vaariable)
-407 is An update or insert value is null. but the object
column name cannot contain null values.(the update or insert
value was null. But the object column was declared as not
nullin the table)
| Is This Answer Correct ? | 11 Yes | 0 No |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
select distinct(empid),distinct(dept),name from EMP will the above query work?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
If I have a view which is a join of two or more tables, can this view be updatable?
What is plan in cobol db2?
What is bind plan?
What is a plan and package in db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
How to find the number of rows in a db2 table?
How to test SQL -911 error while developing COB-DB2 program
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
COBOL 
