Load from Sql database

[gidon500]

Hello

i have an SQL table with App 4,000,000 lines

i want to start the load fro line 3500000

how can i do it with out a condition in the load script ,

thanks

gidon

[its_anandrjs]

Load your table like

Load

Statements

..

...

From Location

Where RecNo( ) > 3500000;

Regards

[its_anandrjs]

For your SQL load statement write a code like

LOAD Region, Country Where RecNo() > 3500000;

SQL SELECT Region, Country

FROM Emp;

Write this statement Where RecNo() > 3500000

[maxgro]

if you want the filter in sql server, I think

Table:

load

  *;

SQL

select * from (

SELECT ROW_NUMBER() OVER (

   ORDER BY (SELECT 1)) AS RowNumber, 

*

FROM YourSqlServerTable

) a

where RowNumber > 3500000;