Interested to Buy Any Domain ? << Click Here >> for more details...
What is ALTER ?
- 3 Answers
- 6881 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 |
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
how to get duplicate records from tables?write qurey for this?
what is static sql? what is dynamic sql? Give me details
What is database manager in db2?
i have a db2 variable how do u declare tht into working storage section ?
What is the connection string to connect to the DB2 Database ?
What is db2 purescale?
What is image copy?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
how to unload different table data into different gdg files/ vsam files.
Is db2 a database?
what is utility for parm lib
COBOL 
