What is the maximum length of a column name in DB2? 18 or
30 or anything other than these?

Answer Posted / ragudeep

30 is the maximum length of the column name

Is This Answer Correct ?    6 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of runstats in db2?

577


can we view the access paths created by dbrm ? how ? thx

6250


How many databases are there?

590


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1651


Explain about open switch business continuity software?

563






What is the function of logging in the db2 database?

643


How to check last update on table in db2?

628


Can you tell me how can you find out the # of rows updated after an update statement?

611


What os does db2 run on?

570


Give the name of some fields form sqlca.

611


Who uses db2?

574


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

584


How to execute stored procedures?

620


Mention the different locking levels that are available in db2.

645


What is package in db2 mainframe?

557