Dynamic SQL ...

Hello

I am new with dynamic SQL. Will you explain how following example works.

EXEC SQL PREPARE my_statement FROM :my_string; EXEC SQL DECLARE emp_cursor

         FOR SELECT empno, ename, sal, comm
                         FROM emp
                        WHERE deptno = :dept_number
EXEC SQL DESCRIBE BIND VARIABLES FOR my_statement
         INTO bind_descriptor;
EXEC SQL OPEN emp_cursor
         USING bind_descriptor;
EXEC SQL DESCRIBE SELECT LIST FOR my_statement
          INTO select_descriptor;
EXEC SQL FETCH emp_cursor
         INTO select_descriptor;

Thanx in advance.
Rajesh Received on Thu Nov 19 1998 - 04:25:38 CST