Where could you look if you had a question about whether a
column has been defined as an index?
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 |
How will fetch last 5 rows from table in db2
The only place of VSAM KSDS in DB2 is?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
my project is insurance management system,how to explain my work environment in interview?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What else is there in the PLAN apart from the access path?
Which is faster delete or truncate?
Where do you specify them?
What if we fail to give values in columns declared as NOT NULL ?
What is db2 command?
how will you retrieve first record in table
What is db2 look?