用的是db2 v9.1 ，想给记录加上行号？这样写了，但不行：
select row_number() over() as num,* from tbP
------解决方案--------------------------------------------------------
select row_number() over() as num,tbP.* from tbP
------解决方案--------------------------------------------------------
select row_number() over(order by t.[FIELD1]) as num, t.* from tbP t