What is the maximum number of tables that can be stored on
a Partitioned Table Space ?
Differentiate between cs and rr isolation levels? Where do you specify them?
What does the CHECK Utility do ?
How do you define a correlated name?
In terms of DB2 indexing, what is the root page?
What is alias in db2?
explain about index with examples
What is drop table?
What do you need to do before you do EXPLAIN?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is sqlca?
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.
How do I connect my db2 database to ibm?