How do we specify index to include or not during bind
process.
- 1 Answers
- 2223 Views
- Satyam, I also Faced
- E-Mail Answers
Answer / Deepak Singh
In DB2, you can specify an index for inclusion or exclusion during the bind process using the INCLUDE and EXCLUDE keywords respectively. Here is a simple example:
CREATE INDEX idx_mytable ON mytable (column1) INCLUDE (column2);
This will create an index on column1, but also include column2 in the index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is the physical storage length of the data types date, time, and timestamp?
what is SPUFI ?
How do you define a correlated name?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the difference between bind and rebind in db2?
On the create tablespace, what does the CLOSE parameter do?
What is catalog database in db2?
What is role in db2?
Give a brief description of db2 isolation levels?
how can u retrieve the data from null values using applicaion program.
COBOL 
