topic Restricting Select rows in Application Development and Automation Discussions

Restricting Select rows

Former Member — Tue, 17 Jul 2007 13:47:27 GMT

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 — Tue, 17 Jul 2007 13:52:09 GMT

hi,

U can use STARTING AT.

Former Member — Tue, 17 Jul 2007 13:57:10 GMT

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 — Tue, 17 Jul 2007 14:02:49 GMT

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 — Tue, 17 Jul 2007 14:06:17 GMT

nop... doesn't work!

more ideas?