Why db2 is called db2?
No Answer is Posted For this Question
Be the First to Post Answer
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
When is the skeleton cursor table created?
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 difference between group by and order by?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
cursor with hold explain ?
What is role in db2?
What is the SQL Communications Area and what are some of its key fields?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is dbrm in db2 database?
Mention the various locks that are available in db2.