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 physical storage length of time data type?
Give some example of statistics collected during RUNSTATS?
Why might full image copies be faster to implement than an incremental image copy?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What is subquery ?
How to get Top 10 Salaries from a Table
how can you access index
What is the clustering index in the db2 database?
What is deadlock?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to create db2 table in mainframe?
why we create view.