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
- 15206 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Name the various locking levels available?
Explain correlated sub-queries.
What are types of indexes?
Which component is responsible for processing sql statements and selecting access paths?
is it compulsory commitment control in journal?
What is database reorganization?
Where can you declare a cursor in a cobol-db2 program?
What are the 2 sqlcodes that are returned?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Define db2.
Is schema the same as database?
Why do chiropractors use drop table?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is package in cobol db2?
What is db2 and what is the use of db2 optimizer?
