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?
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
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What db2 400?
What is iseries database?
What are the contents of a dclmgen?
How would the varchar column remarks defined?
Define data page.
What is difference between isnull and coalesce?
How many types of page locks can be held in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain about rct in db2?
Explain packages.
How to execute stored procedure in db2 command editor?
What is host variable in db2 cobol?
What is db2 optimizer?