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
- 11203 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
What is sqlca?
What are the uses of db2 optimizer?
What is meant by union and union all?
Is schema the same as database?
List out the three types of page locks that can be held.
Mention some fields that are a part of sqlca.
What is node in db2?
How do I import data from excel to db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do you pull up a query which was previously saved in qmf?
Explain the function done by data manager?
What is the maximum No of rows per page?
How to execute stored procedures?
What is the physical storage length of date data type?
What is the latest version of ibm db2?
