row « db2 « Java Database Q&A





1. size of column and row in DB2    coderanch.com

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, ...

2. ROW_NUMBER() OVER in DB2 8.x in Z/OS invoked from Java    coderanch.com

I am trying to accomplish pagination in Java class (DAO) by writing SQL invoked on DB2 8.x running on Z/OS (mainframe). I would like to pass parameter to SQL to retrieve a chunk of records e.g. One SQL will retrieve rows 1 through 250 (incluside) Next SQL will retrieve rows 251 through 500 and so on. I would like to write ...

3. DB2 duplicate rows error code    coderanch.com