Answer / dba

Its very much similar as we sue in other DB

Syntax: CREATE TABLE EMPLOYEE(EMP_ID CHAR(10), NAME VARCHAR(20))

The syntax is usful only in command center
But from GUI its more easier to create table

Answer / 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 difference between Plan and Package

1 Answers   Syntel,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

What are the three types of page locks that can be held?

1 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---

What is catalog database in db2?

0 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---