Interested to Buy Any Domain ? << Click Here >> for more details...
While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?
- 4 Answers
- 11168 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / mr.perfect
IF field is having empty in table , then we can reduce or
increase the size of the field, using the alter statement .
i.e . alter table <tablename>
modify <new columnname ><data type><new size>
if the data in the table is non-empyt, then we cannot alter
the table. better to delete the column and add the same
column to new size.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How does a cursor work?
What types of tables are there in the db2 database?
What is role in db2?
What is the difference between cursor and select statement?
What is the use of with ur in db2?
What is the clustering index in the db2 database?
What is performance tuning db2?
What is db2 connect?
What's The Error Code For Unique Index Voilation?
How does cobol compile db2 program?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Which command is used to connect to a database in DB2 ? Give the Syntax.
How can deadlocks be resolved?
How do you select a row using indexes in db2?
On which levels locks can be applied?
