Interested to Buy Any Domain ? << Click Here >> for more details...
how can you access index
- 4 Answers
- 9809 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mani
After creating index by using CREATE command
CREATE UNIQUE INDEX IDX_EMP ON EMPLOYEE(EMP_ID)
To retreive index:
SELECT INDEX_NAME FROM USER_INDEX WHERE TBNAME='EMPLOYEE'
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pandu
first of all create index
create index<indexname> on <tablename>(<columnname>);
after that we have to access to that by
Select * from <indexname>
Correct me is am i wrong...
Thank You.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ashok kumar
we generally use the folling query for create index
CREAT INDEX <index name> on <table name>(cols1,cols2,...)
for accessing columes :
SELECT ENAME FROM EMP
WHERE cols1 and cols2
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghu
first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename
| Is This Answer Correct ? | 1 Yes | 0 No |
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is phantom read in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Define predicate?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
When do you specify the isolation level? How?
What is the physical storage length of timestamp data type?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is release/acquire in bind?
COBOL 
