Interested to Buy Any Domain ? << Click Here >> for more details...
Where could you look if you had a question about whether a
column has been defined as an index?
- 2 Answers
- 5961 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushmitha
in our company we use Platinum tool.
in platinum for the option 1 - we can see if the column has
been defined as an index.
| Is This Answer Correct ? | 2 Yes | 0 No |
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Can a Db2 table data be retrived through JCL?
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
How do I delete a table in database?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What are PACKAGES ?
What is concurrency in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what needs to be done if a table is in copy pending / check pending status?
How to retrieve rows from a db2 table in embedded sql?
What is role in db2?
What information is used as input to the bind process?
COBOL 
