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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com