Hi, I have two questions about size of column and row in DB2: (1) The maxiumn size of a column depends on the pagesize. For pagesize =4K, the maximun size of a varchar cloumn is 4000. Is the size of the Long Varchar column limited by the pagesize? (2) In DB2 7.2, when I check the help for adding new column, it is said that I can add up to 500 columns, and the total size of the columns must not be gretaer than 4005. Is there a size limit for a entire row in a table? If so, how to calculate the size of a column with data type long varchar, timestamp, and so on.
Don't sweat petty things, or pet sweaty things. But cuddle this tiny ad: