on 09-18-2014 11:01 AM
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?
The fastest way to import data into IQ is via the 'LOAD TABLE ...' command. see the reference doc for the syntax.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.