How we create a tables in db2,what is the process/syntax to
create a table with example plz?
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
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is consistency token in db2?
Define declaration generator (dclgen).
What are packages in db2?
What is check constraint. Explain with example.
What are the 2 sqlcodes that are returned?
List down the types of triggers in the db2 database?
What do you mean by storage group (stogroup)?
What do you mean by between and in? Is between inclusive of specified range values?
What is dclgen (declaration generator)?
How to find the maximum value in a column in the db2 database?
What r the comman abends in db2, jcl and cobol???????
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are types of indexes?
What is lock escalation in db2?
Explain about dbrm.