How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes.
Answer Posted / logaa
if the table column is defined as NOT NULL (with no
default) and if we try to insert a null value we get that
we get a different SQLCODE -407
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is dbrm? What it contains? When it will be created?
What is ibm db2 used for?
Outputs of explain are with matchcols = 0. What does this signify?
What is cloudant database?
What is alias in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How to create backup table in db2?
How to test SQL -911 error while developing COB-DB2 program
What do you mean by between and in? Is between inclusive of specified range values?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Explain about cursor stability?
What is db2 connect?
Give a brief description of db2 isolation levels?