Restricting Select rows

[Former Member]

Hi everyone,

Is there any addition similar to SKIP n ROWS? I want a select statement searching only after n rows.

I can't use an internal table since I'm using dynamic SQL.

Best regards,

André Costa

[Former Member]

hi,

U can use STARTING AT.

[Former Member]

Hi,

1)SKIP for Blank Lines :

Creates blank lines on the output list.

Syntax

SKIP [<n>].

Creates <n> blank lines after the current line in a list. If you omit <n>, inserts one line.

2)SKIP for Positioning :

Absolute positioning for output on a list.

Syntax

SKIP TO LINE <lin>.

Positions the list output in line <lin>.

Reward points if helpful.

Regards.

Srikanta Gope

[Former Member]

srikanta gope:

I meant in a select statement

Roja Velagapudi:

SELECT * FROM SPFLI STARTING AT 90 WHERE (dynamic_sql_table).

??? Let's see, answer in a minute, reward points on your way if you'r right...

[Former Member]

nop... doesn't work!

more ideas?