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 / hi
Yes, it's possible to increase/decrease the size. While
decreasing, need to make sure that none of the records
present in the column conflict the modification. e.g. to
reduce the size of the column which is CHAR(6) to CHAR(4),
with one of the record value as 'ABCDE' will give an error.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of using commit?
What is check constraint. Explain with example.
List down the types of triggers in the db2 database?
What language is db2 written in?
What is cascading rollback?
What is a bind in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is netezza database?
How to connect to db2 database from windows command line?
List down the data types in the db2 database.
What is the physical storage length of date data type?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is performance tuning db2?
What is a system catalog table in db2?
What is database manager in db2?