sql - 存储过程中的分页

Question

我想根据以下link进行自定义分页:

但我的存储过程在informix中:

所以我搜索等效的 row_number()我找到了这个 solution

但是当我在我的程序中使用它时，我收到以下错误:

SQL error -944 Cann't use "first","limit","skip" in this context !

如何用informix规则重写前面链接中的存储过程？

我的程序有多个工会是这样的:

create procedure get_inbox_page(p_emp_num smallint, p_task_code smallint, p_main_code smallint default 0, p_year smallint default 0,p_page int)
returning varchar(60) as v_page_view, varchar(60) as v_task_name, smallint as v_task_code, varchar(60) as v_sp_name, varchar(60) as v_db_name, varchar(60) as v_column_key,  smallint as v_trans_serial, 
    DATETIME YEAR TO FRACTION(3) as v_trans_date, varchar(60) as v_trans_desc , varchar(60) as v_emp_name, varchar(60) as v_values_key, smallint as v_old_state_serial, 
    smallint as v_new_state_serial, smallint as v_main_code, smallint as v_year, varchar(60) as v_page_new, smallint as v_task_type, smallint as v_task_status,smallint as v_mail_maincode,smallint as v_mail_year,smallint as v_mail_number,smallint as v_trans_year , smallint as candidate_flag ;

Select  ......

UNION 

Select ......

UNION 

Select ......

Answer 1

您不能使用 FIRST , SKIP等等，因为每个 SELECT UNION内的声明收藏是自成一体的。

也许你可以尝试创建一个 VIEW封装了 SELECT ... UNION ... SELECT逻辑，然后应用 FIRST/SKIP逻辑。