|
|
| Author |
Message |
karthi_ind
Active User
Joined: 24 Feb 2004
Posts: 64
Location: Chennai
|
|
|
|
hi
can anyone answer my questions
1) What is index? Diff. types of index (explain)
Whatz the use of index?
2) how can we create stored procedures, trigger in db2
(with examples)
3) what is dynamic sql?
4) diff. types of locking. explain ?
5) how can i enable or disable primary or foreign key?
(When i use alter it shows error)
6) diff. between QMF and SPUFI? |
|
| Back to top |
|
 |
References
|
 Posted: Sat Jul 31, 2004 3:09 pm Post subject: Re: questions |
|
|
|
|
karthi_ind
Active User
Joined: 24 Feb 2004
Posts: 64
Location: Chennai
|
|
|
|
can anyone answer these questions?
Why no answers? |
|
| Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003
Posts: 1494
|
|
| Back to top |
|
|
mcmillan
Site Admin
Joined: 18 May 2003
Posts: 906
Location: India
|
|
|
|
Hi Karthi,
| Quote: |
| What is index? Diff. types of index (explain) |
Index is another table which contains the column in ascending/descending order.
Unique Index/ Primary index / Non-nique index etc...
| Quote: |
| What's the use of index? |
To search the table more efficiantly
| Quote: |
| what is dynamic sql? |
If you know the SQL statements at compile time it's static SQL, at Runtime it's Dynamic SQL.
| Quote: |
| diff. types of locking. explain ? |
Locking row level, page level, table level & table spce level available.
| Quote: |
| how can i enable or disable primary or foreign key? |
ALTER TABLE EMP
DROP PRIMARY KEY.
ALTER TABLE EMP
ADD PRIMARY KEY(empno)
| Quote: |
| diff. between QMF and SPUFI? |
QMF - Query Management Facility
SPUFI - SQL processor Using File Input
In SPUFI you should create two data sets to provide & view I/O
In QMF data sets not necessary. In QMF you can generate & print reports.
in SPUFI not like that. |
|
| Back to top |
|
|
|
|
