Hi All,


Now, I need to do the bulk insert (load) data into to vectorwise db, I tried to use the Ingres drive and its bulk components, but failed, any experts can help me? Please help, thanks.

Talend version: 5.0.2

Regards,
Peter.


============Below is the information:
Starting job BULKPOCEXEC at 11:06 23/05/2012.

[statistics] connecting to socket on port 3495
[statistics] connected

C:\Talend\TOS_DI-Win32-r78327-V5.0.2>set II_TM_ON_ERROR=NOCONTINUE

C:\Talend\TOS_DI-Win32-r78327-V5.0.2>set II_TM_SWITCH=true

C:\Talend\TOS_DI-Win32-r78327-V5.0.2>sql sgvectdevdb1::edw_s  0<C:\DOCUME~1\peter_li\LOCALS~1\Temp\ingres_sql_20120523110631.sql
INGRES TERMINAL MONITOR Copyright 2010 Ingres Corporation
Ingres Microsoft Windows Version II 10.0.0 (int.w32/132) login
Wed May 23 11:06:33 2012
Enter \g to execute commands, "help help\g" for help, \q to quit

continue
* * * go
* * *
SET AUTOCOMMIT OFF
Executing . . .

continue
* * *
SET NOJOURNALING
Executing . . .

continue
* * *
SET SESSION AUTHORIZATION CURRENT_USER
Executing . . .

continue
* * * * * * * * * * * * * * * * * * * * * * *
MODIFY s_csn_ps_nc_comm_cmpv_vw_bulkpoc TO TRUNCATED;

COPY TABLE "s_csn_ps_nc_comm_cmpv_vw_bulkpoc" (
ID=char(0)comma WITH NULL ('[NULL]') ,
COMPANY=char(0)comma WITH NULL ('[NULL]') ,
EFFDT=char(0)comma WITH NULL ('[NULL]') ,
EFF_STATUS=char(0)comma WITH NULL ('[NULL]') ,
DESCR=char(0)comma WITH NULL ('[NULL]') ,
DESCRSHORT=char(0)comma WITH NULL ('[NULL]') ,
LEGAL_TYPE=char(0)comma WITH NULL ('[NULL]') ,
RUN_PERIOD=char(0)comma WITH NULL ('[NULL]') ,
RUN_DATE=char(0)comma WITH NULL ('[NULL]') ,
src=char(0)nl)
FROM
'C:/Talend/TOS_DI-Win32-r78327-V5.0.2/workspace/ps_nc_comm_cmv_vw_bulkpoc.csv'
WITH
ROLLBACK=ENABLED,
ON_ERROR=TERMINATE,
ERROR_COUNT=1;

COMMIT
Executing . . .

E_US15B9 MODIFY: 's_csn_ps_nc_comm_cmpv_vw_bulkpoc' is a VectorWise table.
    Statement is unsupported.
    (Wed May 23 11:06:33 2012)

continue
* * *
ROLLBACK
Executing . . .

continue
* *
Ingres Version II 10.0.0 (int.w32/132) logout
Wed May 23 11:06:33 2012
1859 milliseconds
[statistics] disconnected
Job BULKPOCEXEC ended at 11:06 23/05/2012. [exit code=0]

Last edited by PETER_LG (2012-05-23 05:09:38)