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?
Answers were Sorted based on User's Feedback
Answer / hameed shaik
In Db29 we can alter the column size but cannot delete the column..
I did it so many times.. ALTER TABLE Tablename ALTER COLUMN columnname SET DATA TYPE VARCHAR(51)
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / naidu sekhar yandrapu
once enter into column length ,we can increase the data length if a table is empty but if the table is non empty we can only
increase the(data length)
in this situation add one more column should be size is 8.
Is This Answer Correct ? | 5 Yes | 6 No |
Answer / rahul
If table is empty then we alter this column to any length,
but if some data got inserted into the table then we can
also decrease the column length upto largest data size
available in that perticulat column.
Is This Answer Correct ? | 1 Yes | 5 No |
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How does coalesce work?
Explain about cursor stability?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
what is SPUFI ?
What are the contents of a DCLGEN?
how to take the back up of the DB2 table.
What is db2 bind?
What is the use of db2 optimizer?
How do I delete a table in db2?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
Mention the location where the output received from explain statement is stored.