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.
2 8784For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
2 8303Post New iGate DB2 Interview Questions
What happens with existing visualforce pages in lightning experience?
what is the difference between require() and include() when an error is encountered?
What is the use of innodb in mysql?
You need to search for the string “tecmint” in all the “.txt” files in the current directory. How will you do it?
How do you record pp&e and why is this important?
What is pl/sql table? Why it is used?
How to convert a string to a number using javascript?
What are content pages?
how do you use commitment control in rpg program ?
Is null == null c#?
Explain the fdd in gsm technology?
What are the main features of SPM in Cassandra?
What is a class loader?
What is bcnf normalization form?
How big is windows 10 install?