Interested to Buy Any Domain ? << Click Here >> for more details...
What is a DB2 access path?
- 1 Answers
- 7236 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 |
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
Can a array declared with an index be displayed(readable format) in spool?
What can the Locate option of the Repair Utility accomplish?
What is cursor?
Define sqlca.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is cascading rollback?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
How connect db2 database to datastage?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
what is sql abend code -801,-802?
COBOL 
