DB2 的分页

Oracle,Sql Server, MySql, DB2使用sql分页(ZZ)的DB2:
select * from (select *,rownumber() as ROW_NEXT from tablename) where ROW_NEXT between min and max
用php的db2_exec执行会产生这样的错误:
42601:[IBM][CLI Driver][DB2/6000] SQL0104N An unexpected token “*” was found following “lect * from (select”. Expected tokens may include: “?”. SQLSTATE=42601 SQLCODE=-104
后来我看了很多篇文章,发现都是有指定栏位名称居多,用*就不能表示,后来灵机一动,用tablename.*,yes 可以动!
想不出来为何不行?不过我这样可以完成我的目的就不再追就了!