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 is the meaning concurrency in the db2 database?
What is an instance database?
What is a dbrm in db2?
How to resolve -502 sql code in DB2?
What are the full forms of spufi and dclgen and why are they used?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is EXPLAIN?
Can we delete records from view?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Once you create a view, where would information about the view be stored?
What is bind in db2?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?