1. size of column and row in DB2 coderanch.comHi, 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.comI 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 |