What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
- 1 Answers
- 7484 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 |
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
Describe what a storage group(STOGROUP) is?
What is -904 sql code? How to resolve it?
What is deadlock in db2?
How to retrieve rows from a db2 table in embedded sql?
How to handle null values in db2
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
what is SPUFI ?
Mention the location where the output received from explain statement is stored.
What is ibm db2 connect?
how will you retrieve first record in table
What is dclgen in db2?
COBOL 
