Interested to Buy Any Domain ? << Click Here >> for more details...
How we create a tables in db2,what is the process/syntax to
create a table with example plz?
- 2 Answers
- 15446 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 14 Yes | 5 No |
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 |
Can you tell me how can you find out the # of rows updated after an update statement?
What is the use of dclgen in db2?
What are iseries servers?
How will fetch last 5 rows from table in db2
What does a deadlock mean in DB2?
what is the difference between join and union?
What is universal database?
how to copy the host variables from ps file into cobol program other than include statement
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
Update command
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is db2?
COBOL 
