Category: DB2

IBM DB2 Error Code -556 – revoke-target cannot have the privilege

In this post, you’ll learn about the IBM DB2 Error -556 and the reason why you are receiving it IBM DB2 Error Code : -556 Reason for this Error in DB2 revoke-target CANNOT HAVE THE privilege PRIVILEGE object-name REVOKED BY revoker-id BECAUSE THE REVOKEE DOES NOT POSSESS THE PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT

IBM DB2 Error Code -4733 – the alter table statement cannot be exec

In this post, you’ll learn about the IBM DB2 Error -4733 and the reason why you are receiving it IBM DB2 Error Code : -4733 Reason for this Error in DB2 THE ALTER TABLE STATEMENT CANNOT BE EXECUTED BECAUSE COLUMN column-name IS MIXED DATA, OR THE DATA TYPE OR LENGTH SPECIFIED DOES NOT AGREE WITH THE EXISTING DATA TYPE OR LENGTH

IBM DB2 Error Code -4747 – the create or alter table statement fail

In this post, you’ll learn about the IBM DB2 Error -4747 and the reason why you are receiving it IBM DB2 Error Code : -4747 Reason for this Error in DB2 THE CREATE OR ALTER TABLE STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE. UNSUPPORTED FUNCTIONALITY:functionality-keyword.