Explain how can you do the explain of a dynamic sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
What is db2 stogroup?
What is isolation level?
cobol-db2 runjcl please?
When is the access path determined for dynamic SQL?
Explain about dbrm.
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is a synonym? How is it used?
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 a view? Why use it?
what is the difference between join and union?
Once you create a view, where would information about the view be stored?
What are the various isolation levels possible?