i have cobol+ db2 program but it contains n number of
subprograms for this how many dbrm members i need to
mention in bind process
Answers were Sorted based on User's Feedback
Basically n+1, one for the main programs and n for n sub
programs.
Is This Answer Correct ? | 4 Yes | 0 No |
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
How to define the data items to receive the fetch items for the SQL?
What is a synonym ?
What is a bind card?
Explain what are the various isolation levels possible?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What will the DB2 optimizer do?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is a bind in db2?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is dpf in db2?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?