|
View previous topic :: View next topic
|
| Author |
Message |
t1nt1n
New User
.jpg)
Joined: 08 Jul 2005
Posts: 31
|
|
|
|
1) What are the types of tablespaces ?
2) Difference between DB & Tablespace, which is physical ? |
|
| Back to top |
|
 |
t1nt1n
New User
Joined: 08 Jul 2005
Posts: 31
|
|
|
|
one more qtn
3) what are the contents of a DCLGEN ? |
|
| Back to top |
|
|
iknow
Active User
Joined: 22 Aug 2005
Posts: 411
Location: Colarado, US
|
|
|
|
Hi,
Search the forum. I think these topics have already been discussed.
Hope this helps. |
|
| Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
|
|
HI,
| Quote: |
| 1) What are the types of tablespaces ? |
Simple Tablespace
Segmented Tablespace
Partitioned Tablespace
| Quote: |
| 3) what are the contents of a DCLGEN ? |
1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.
2. A host language copy book that gives the host variable definitions for the column names.
Hope it helps
Regards
Rupesh |
|
| Back to top |
|
|
t1nt1n
New User
Joined: 08 Jul 2005
Posts: 31
|
|
|
|
| Thanks Rupesh. |
|
| Back to top |
|
|
|
|
