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
- 11482 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is bind package and plan in db2?
Is db2 relational database?
What are union and union all?
Which component is responsible for db2 startup and shutdown?
What is host variable?
List out the data types available.
Can we delete records from view?
How do I optimize a query in db2?
Before you give the explain statement, what are the prerogatives?
What is the difference between bind and rebind in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are the bind parameters ibm db2?
How to execute stored procedure in db2 command editor?
How do I create a view in db2?
