If the main program has only cobol statements and subprogram
has the db2 statements what is the procedure for
precompilation. for which program we need to do the
precompilation
- 1 Answers
- 6327 Views
- IBM, I also Faced
- E-Mail Answers
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Mention the various locks that are available in db2.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How many Buffer pools are there in DB2 and what are they?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
is it possible to get -811 error when you use cursors. why?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is runstats utility in db2?
Which command is used to remove all rows from a table?
What will happen, while trying to close the closed cursor.
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
COBOL 
