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

What is database alias db2?

593


What is explain in db2?

579


What is performance tuning db2?

606


What do you mean by between and in? Is between inclusive of specified range values?

661


What is the role of union all and union

645






What are bind parameters in db2?

607


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

599


What are union and union all?

535


What is the maximum No of rows per page?

622


What is sqlca’s maximum length?

664


What is package in db2 mainframe?

552


How do we specify index to include or not during bind process.

1671


What is bind and rebind in db2?

645


What is dbrm library?

572


How do I copy a table in db2?

571