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 does CURRENTDATA option in bind indicate
What is cloudant database?
What is null indicator in cobol db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What is the use of dclgen in db2?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is a synonym ?
What is concurrency in db2?
define clustering index.
What is difference between *omit and *nopass?
What is null indicator in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?