create a table in such a way that Delete cannot be used?

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Posts: 1
Joined: Wed Sep 17, 2014 2:16 pm

create a table in such a way that Delete cannot be used?

Post by ramu9935 » Wed Sep 17, 2014 2:21 pm

How to create a table in db2 in such a way. delete should be disabled i.e no one should be able to delete any row or column . But can be able to insert a new row.

Please suggest how to do the above.Thanks alot !

Posts: 48
Joined: Tue May 06, 2014 11:22 am

Post by dhiraj » Mon Oct 13, 2014 3:51 pm

Don't provide GRANT option for DELETE to any one...
--Dhiraj Mishra

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others