You want to be able to tell the procedure how much records to skip from
a parameter, right? Then you have to use the new execute statement, like
this

for
execute statement 'select skip '||cast(cant as varchar(10))||'
description from tabla '
into :NombreEsp
do
suspend;

Ernesto Cullen



williamrocha wrote:

>Hi,
>
> I whant to create a procedure with a SELECT like this
>
>SELECT SKIP :N * FROM TABLE
>
> How to do?
>
>
>