Is db2 relational database?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Mention and explain the contention situations caused by locks?
Explain various types of locks in db2?
What is isolation level?
can any one expalin check point with an example?
What does sqlcabc has?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is buffrpool? Where we use it ?
What are the 2 sqlcodes that are returned?
How do you select a row using indexes in db2?
What is coalesce in db2?
What is cursor in dbms?