First pass at fixing SQL Server 2000 pagination

This is an attempt to restore SQL Server 2000 pagination while reusing the existing local variables.
Can you comment why DB2 doesn't support this query? Pertinent link or small explanation. Thanks!