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
If I have a view which is a join of two or more tables, can this view be updateable?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the usage of open cursor command?
What are db2 objects?
What is host variable?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
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?
List out the buffer pools in db2
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is coalesce in db2?
What is difference between isnull and coalesce?
Explain what are the various isolation levels possible?
What is a page in db2?
What is cloudant database?
Explain various types of locks in db2?