What are db2 error codes -305 and -407. What is the
difference between these 2 error codes ?
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 |
What is the difference between CS and RR isolation levels?
i want to delete 20th million record how ?
Can we update view in db2?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is phantom read in db2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What are PACKAGES ?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
Where can you declare a cursor in a cobol-db2 program?
What is a precompiler?
What is the difference between spufi and qmf?