Interested to Buy Any Domain ? << Click Here >> for more details...
How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it?
- 6 Answers
- 10901 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anish
for the 1st question:
v can create table by the COMMAND
CREATE TABLE table-name
column1 char(9)
.
.
...so on
And according to your installation u have to mention the
tablespace name & DB name.
for the 2nd question:
ALTER TABLE table-name
MODIFY USER_ID CHAR(12);
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the syntax for seeing the columns and data types of a table in the db2 database?
Are view updateable?
What is the purpose of using commit?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the two types of logging in the db2 database? Explain them.
How to run db2 command in windows?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Give a brief description of db2 isolation levels?
How do I start db2 in windows?
What is the syntax for FETCH in DB2 ?
What do you mean by storage group (stogroup)?
What is sqlca’s maximum length?
Mention data types used in db2 ?
What is the use of dclgen in db2?
What is cursor in dbms?
