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

What is database alias db2?

1177

---

What is coalesce in db2?

1184

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2772

---

What is cursor in dbms?

1112

---

What is the difference between nvl and coalesce?

1107

---

What do you mean by rollback?

1030

---

Is db2 a programming language?

1101

---

What are the different types of base tables?

1163

---

Why do chiropractors use drop table?

1164

---

What is a db2 collection?

1107

---

What is check constraint. Explain with example.

1162

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

---

What is commit in db2?

1104

---

How to find schema of a table in db2?

1066

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1117

---