ISQL import data by running insert query, speed is slow.

[Former Member]

I have more than 2 million row of data needed to be insert into Sybase IQ in ISQL. The speed is slow, what is other way to insert the data except by using insert statement by open a file?

[tom_kim]

The fastest way to import data into IQ is via the 'LOAD TABLE ...' command. see the reference doc for the syntax.

[Former Member]

set temporary option date_order='ymd'

go

set temporary option date_format='YYYY-MM-DD'

go

set option public.MINIMIZE_STORAGE = 'ON';

truncate table EventDemo.fact_actual;

commit;

load table EventDemo.fact_actual(

period_date,

product_code,

channel_code,

actual_amt,

actual_qty,

actual_cogs

)

from 'C:\Users\DELL\Desktop\fact_actual_test2.csv'

quotes off

escapes off

format BCP

delimited by '|'

row delimited by '\n'

;

commit

;

rollback

;

Thank for your reply, found out this script in instruction lesson 2.