what is dynamic cursor?gives syntax for this?

Question Posted / anji reddy

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

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

Post New Answer

More DB2 Interview Questions

Can we use select * statement in cobol program without giving field names ???

3 Answers Zensar,

What is a cursor in programming?

0 Answers

How to resolve -803 sql code in DB2?

3 Answers Cap Gemini,

what is check point and restart Logic ? why do we go for that ??

2 Answers CGI, UST, Xansa,

What is COPY PENDING status?

6 Answers

Why do we bind in db2?

0 Answers

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers Accenture,

What is ACQUIRE/RELEASE in BIND?

3 Answers Cognizant,

What is lock contention?

1 Answers

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers

Can we update view in db2?

0 Answers

How to handle null values in db2

4 Answers

For more DB2 Interview Questions Click Here