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
- 15202 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 |
What is dynamic SQL?
Where do you specify them?
what is cursor stability?
Explain how can you do the explain of a dynamic sql statement?
What will the DB2 optimizer do?
how to resolve -805. give clear explination for that
How to define the a field which accepts value till 99999.99 in db2
Mention the definition of cobol in varchar field.
Explain about rct.
How to check last update on table in db2?
Explain the use of the WHERE clause.
is it possible to get -811 error when you use cursors. why?
COBOL 
