Answer Posted / ratheesh nellikal

Answer posted by Dba is correct.
But in real time schenario we should be more specific.
eg:
CREATE TABLE SCHEMA.TABLENAME
(column1 DATATYPE,
column2 DATATYPE,
column3 DATATYPE)
IN tablespace_name
INDEX IN index_tablespace;

so try to follow this syntax (u can have more options with
this command like u can even specify the tablespace name wr
do u want to store ur LONG object 'LONG IN
long_tablespace' )

Cheers,
Ratheesh Nellikal

How to compare data between two tables in db2?

1032

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1975

---

What is difference between rollback and commit?

1092

---

How to take backup of table in db2?

1021

---

What is the physical storage length of date data type?

1189

---

What is cobol db2?

933

---

What are packages in db2?

972

---

What is runstats db2?

964

---

What do you mean by rollback?

932

---

define clustering index.

978

---

What is query_cache_limit?

928

---

How many databases can be created inside an instance in db2 ?

978

---

What is db2 optimizer?

1178

---

When do you specify the isolation level?

972

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1228

---