What's the maximum number of characters that a tablename
can have?

Answer Posted / s

In DB2 V8, it is increased to 128 bytes.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does coalesce work?

594


What is cascading rollback?

629


What is the role of union all and union

658


What is ibm db2 connect?

585


How to run db2 command in windows?

658






What does reorg do in db2?

585


What is the difference between db2 and oracle?

685


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1831


How and when does the db2 enforces the unique key?

625


Differentiate between cs and rr isolation levels? Where do you specify them?

593


Can one database have multiple instances?

587


How can we retrieve the total number of records in RPG & CLLE?

209


What is buffer pool and list some of them?

632


How to create backup table in db2?

654


What parameters are used to control the free space in DB2?

651