What is reorg and runstats in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is pagespace?
What is UNION,UNION ALL?
What is a bind in db2?
What is host variable?
What types of tables are there in the db2 database?
What is the self-referencing constraint?
Explain about open switch business continuity software?
What is catalog database in db2?
Which isolation level provides maximum concurrency?
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 difference between *omit and *nopass?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?