How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it?

Answer Posted / guest

It is always possible to increase the size of the variable.
It is not possible to decrese the size.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is a typical db2 batch pgm executed?

916


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2595


Which component is responsible for db2 startup and shutdown?

848


Why do we bind in db2?

926


Mention the various locks that are available in db2.

830


What action db2 takes when a program aborts in the middle of a transaction?

912


What is dclgen in db2?

925


When the like statement is used?

937


How to retrieve rows from a db2 table in embedded sql?

1048


What is ibm db2 used for?

859


When do you specify the isolation level?

829


Where do you specify them?

915


What are host variables in db2?

845


What happens in bind step in a db2 program?

763


What is the role of data manager in the db2 database?

896