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 7586For 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 7228Post New iGate DB2 Interview Questions
Explain what is sql server english query?
What is a what if scenario?
Are java and javascript the same?
What is electrical diversity factor in electrical installations?
What is preprocessor in .net and type, where it use?
How do you set goals for your team? And how do you track these goals?
What is better than vinyl windows?
Explain me what is fast enumeration?
What are the different attributes used with regular expression?
What is web router?
What does f1 key do in excel?
What is dynamic object interoperability services provided by dlr to clr?
What are the reasons that winrunner fails to identify gui object?
In asp.net, how can you validate drop down box?
When a program is created and need to be transported to prodn does selection texts always go with it? If not how do you make sure? Can you change the cts entries? How do you do it?