what is dynamic cursor?gives syntax for this?



what is dynamic cursor?gives syntax for this?..

Answer / harsha

Working-Storage Section.
01 WS-FIELD.
49 WS-FIELD-TEXT PIC X(40).
49 WS-FIELD-LEN PIC S9(4) COMP.

PROCEDURE DIVISION.

MOVE +45 TO WS-FIELD-LEN.
MOVE 'UPDATE TAB1
SET ----=:----- WHERE ---=:----'
TO WS-FIELD-TEXT.
EXEC-SQL
EXECUTE IMMEDIATE:WS-FIELD
END-EXEC.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What keyword does an SQL SELECT statement use for a string search?

2 Answers  


What is isolation level in db2?

0 Answers  


What is the role of schema in the db2 database?

0 Answers  


What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,


Mention the various locks that are available in db2.

0 Answers  






What will the COMMIT accomplish?

5 Answers  


List down the data types in the db2 database.

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


What is cursor?

2 Answers  


When the like statement is used?

0 Answers  


How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,


How can you do the explain of a dynamic sql statement?

0 Answers  


Categories