Working-Storage Section. 01 WS-FIELD. 49 WS-FIELD-TEXT PI

what is dynamic cursor?gives syntax for this?

Question Posted / harsha

1 Answers
5400 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How do I import a csv file into db2?

995

What is dbrm? When it will be created?

1034

What is the picture clause of null indicator variable?

1138

What is the role of data manager in the db2 database?

1111

How do I start db2 in windows?

1104

Is db2 a programming language?

1054

How to test SQL -911 error while developing COB-DB2 program

7584

What is database reorganization?

1135

can we view the access paths created by dbrm ? how ? thx

7104

Explain about mirror activator disk mirroring?

1018

What is db2?

1186

How and when does the db2 enforces the unique key?

1086

What is the role of schema in the db2 database?

1279

What is isolation level in db2?

1015

What are db2 objects?

1053