What is a DB2 access path?
- 1 Answers
- 6687 Views
- I also Faced
- E-Mail Answers
Answer / guest
It is used to determine efficient way to access db2 tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
how can u nderstand the sql stmts executed successfully or not ?
What is a result table?
what is the Foreign key? explain?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is the clustering index in the db2 database?
What is syscat in db2?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is difference between rollback and commit?
what is the use of commit ? and what is the syntax?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
COBOL 
