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

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?

Question Posted / guest

6 Answers
10695 Views
Wipro, I also Faced
E-Mail Answers

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 view db2?

1019

What is scrollable cursor in db2?

1014

List out the data types available.

1102

What is the cobol picture clause of the db2 data types date, time, timestamp?

1028

Can there be more than one cursor open for any program?

1135

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2880

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11636

How can you count the number of rows from a table tab?

1055

How many databases can be created inside an instance in db2 ?

994

What is the difference between oracle and db2?

1047

What is access path in db2?

934

What is difference between isnull and coalesce?

1016

What is the result of open cursor statement?

1043

What does reorg do in db2?

992

What is the advantage in De-normalizing tables in DB2?

1131