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
- 15308 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 the function of buffer manager?
Explain db2.
What is the difference between drop table and delete table?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Is schema the same as database?
What is db2 bind?
What happens in bind step in a db2 program?
How to resolve deadlock issue
How is a typical db2 batch pgm executed?
What is the purpose of the WHENEVER statement?
Explain what a plan is?
COBOL 
