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 |
How to execute stored procedure in db2 command editor?
What is sqlcode -922 ?
How many types of page locks can be held in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
Return code 100 means?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are foreign keys in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How to take backup of table in db2?
How to resolve -504 sql code in DB2?
What is correlated subquery?
db2 restart logic ?