Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6898 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
ALTER is a DDL (data definition language) statement to make
changes to the description of the table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / om yadav
modify the structer of table.
1. add column.
2. midify column.
3. drop column.
4. add or remove constraint.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jitendra
ALter is to change db2 table definition. for eg:
Alter tablename
add column number(11,2)
| Is This Answer Correct ? | 0 Yes | 0 No |
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
Define predicate?
Which transaction use a command thread ?
What does a deadlock mean in DB2?
What is innodb buffer pool?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain correlated sub-queries.
What types of tables are there in the db2 database?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Can we install 2 different versions of Db2 on same mainframe?
In terms of DB2 indexing, what is the root page?
COBOL 
