Catalog table that shows readable/updatable views in Db2 v11 NFM

Bharath Nunepalli

Catalog table that shows readable/updatable views in Db2 v11 NFM

Hi all,
I know how to find whether a view is just readable or not.
I'm wondering if there is any Db2 catalog table that has a value for readable/updatable views.

 

I haven't found anything like that in Db2 v11 NFM. Not sure if that's available in Db2 v12.

Please let me know if you find about that.

 

 

Bharath Nunepalli,

Senior DB2 DBA.