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 do I add a column to a table in db2?

1062

---

What are the different types of base tables?

1044

---

How to find the number of rows in db2 tables?

1015

---

Why cursor is used in db2?

998

---

What is null indicator in db2?

1061

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2323

---

What are the contents of a dclmgen?

1082

---

What is explain in db2?

974

---

Is schema the same as database?

1018

---

What is the difference between nvl and coalesce?

1025

---

What are the benefits of using the db2 database?

1172

---

Mention the downsides of page level lock.

1120

---

What is dpf in db2?

1062

---

How to create backup table in db2?

1056

---

What is an instance database?

1016

---