How does cobol compile db2 program?
Which component is used to execute the sql statements?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is db2 connect?
What is a view? Why use it?
How would you find out the total number of rows in a db2 table?
How to fetch the last row from the table in SQL (db2)?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is db2 look?
what is rebinding ?
What is meant by isolation level?
What do you mean by rollback?
What is FREEPAGE and PCTFREE in TABLESPACE creation?