When you delete data from tables using SQL DB2 in your programs, you should always use a condition in the DELETE statement, unless you want to delete all the rows from a table.

System information: Operating system (distribution) and version win 10 DBeaver version 7.2.2 Connection specification: Database name and version Hive 2.3.2 Describe the problem you're observing: Table ...

2. Describe the problem a. From the Python program we are able to SELECT from the table but not able to UPDATE or DELETE the table. b. From any SQL tool (Golden Benthic), we are able to SELECT, UPDATE ...