What is a clustered index?
Answer / pradeep
a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence
datarows will be arranged based on the index in leaf pages
| Is This Answer Correct ? | 10 Yes | 3 No |
How do you stop a db2 database in linux?
What is null indicator in db2?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is check constraint in db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Why cursor is used in db2?
can all users have the privilage to use the sql statement select * (dml)?
How would the varchar column remarks defined?
i have a db2 variable how do u declare tht into working storage section ?
how to get duplicate records from tables?write qurey for this?
What is check constraint. Explain with example.
What is page size in db2?