Can I use LOCK TABLE on a view?
Answer / s
You can use LOCK TABLE on any table. View is not a
physical object.
Is This Answer Correct ? | 4 Yes | 2 No |
Which component is responsible for db2 startup and shutdown?
What is copy pending and check pending in db2?
How to see the structure of db2 table??
how to u check the query is executing or not ?where will u check for sqlcode ?
How do I connect my db2 database to ibm?
Explain various types of locks in db2?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
Name the lockable units in DB2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is filter factor?
Highlight all the advantages that are attached to a package.
How will fetch last 5 rows from table in db2