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 |
What keyword does an SQL SELECT statement use for a string search?
What is isolation level in db2?
What is the role of schema in the db2 database?
What is the difference between SYNONYM and ALIAS?
Mention the various locks that are available in db2.
What will the COMMIT accomplish?
List down the data types in the db2 database.
pls tell me abt the normalization five types....
What is cursor?
When the like statement is used?
How to resolve -502 sql code in DB2?
How can you do the explain of a dynamic sql statement?