You can use LOCK TABLE on any table. View is not a physical object.

Can I use LOCK TABLE on a view?

Question Posted / s

Answer Posted / s

You can use LOCK TABLE on any table. View is not a
physical object.

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to restart a DB2 program?

1827

Before you give the explain statement, what are the prerogatives?

969

How can we retrieve the total number of records in RPG & CLLE?

577

How do I import data from excel to db2?

1011

How can record locking be achieved in those DB2 versions which do not support it?

1019

What is load replace in db2?

936

What is the difference between cursor stability and repeatable read isolation levels?

1115

What is a storage group (stogroup)?

1189

Can there be more than one cursor open for any program?

1123

What is the use of runstats in db2?

1022

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865

What is the meaning concurrency in the db2 database?

1056

What is runstats db2?

964

Where do you specify them?

1166

What is sqlca?

999