What is a DB2 access path?
Answer / guest
It is used to determine efficient way to access db2 tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
Explain an outer join?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
what is dynamic cursor?gives syntax for this?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
what's the best lock size that you could use when you create a tablespace?
How do I delete a column in db2?
how to resolve -811 error. give clear explination
What is a lock?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .