Found 98 Questions for DB2

How will you fetch the 2nd column from the current position of the scrollable cursor defined on ORDERS DB2 table?

Published on 15-Sep-2020 14:42:45

A scrollable cursor is defined on the ORDERS DB2 table. How will you fetch the 9th row of the cursor present in absolute position?

Published on 15-Sep-2020 14:40:27

Explain the difference between SENSITIVE and INSENSITIVE scrollable CURSOR with the help of an example and syntax

Published on 15-Sep-2020 14:38:13

Write the syntax to declare a scrollable cursor on the ORDERS DB2 table.

Published on 15-Sep-2020 14:36:49

How will you implement a logic which will enable the cursor to read data in both forward and backward direction?

Published on 15-Sep-2020 14:34:20

What is the use of the ATOMIC and NON ATOMIC clause in multi row insert? How will you use them in a COBOL-DB2 program? Explain with an example.

Published on 15-Sep-2020 14:28:29

How to insert multiple rows in a DB2 table using a single INSERT command in a COBOL-DB2 program?

Published on 15-Sep-2020 14:25:59

What is the definition for host variables in case of multi row fetch? Explain with the help of an example.

Published on 15-Sep-2020 14:20:56

How will you extract multiple rows from a DB2 table in a single FETCH call?

Published on 15-Sep-2020 14:18:57

What will be the result if we try to FETCH from the CURSOR which is not OPEN? And what will be the result if we try to OPEN a CURSOR which is already opened?

Published on 15-Sep-2020 14:17:16
1 2 3 4 5 6 7 ... 10 Next
Advertisements