Interested to Buy Any Domain ? << Click Here >> for more details...
How do you find the maximum value in a column in db2?
- 0 Answers
- 1152 Views
- I also Faced
- E-Mail Answers
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.
What is the maximum No of rows per page?
Is there any advantage to denormalizing DB2 tables?
Can we delete records from view?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Can we insert update delete in view?
what are the bind parameters?
How is deadlock resolved?
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 the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What are packages in db2?
What is precompiler in db2?
COBOL 
