IQ REPLACE LOAD

[former_member191072]

Hello Guys,

I want to load from CSV file to IQ16 table , but this table has primary key and CSV has existing primary key data.

I want to take this existing data as update , new data as insert in IQ Load command. But It seems to me, IQ Loader doesn't have this feature .

I am thinking another method ... ie) Load to another table and use insert-select command and update command .

However , I think some guys has same trouble in IQ. How to solve this case ? Does anyone know good method ?

And I googled about this, "Sybase ETL" has this feature for IQ. But this products is obsoleted? Data Services has same feature ?

Rgs,

Jim

[tayeb_hadjou]

Hi Jim,

To load only the new rows and reject the duplicates, try load options

IGNORE CONSTRAINT UNIQUE , MESSAGE LOG ROW LOG.

Eg.

Load table (....

)

....

IGNORE CONSTRAINT UNIQUE 0

MESSAGE LOG 'c:\\client-data\\load.trace'
ROW LOG 'c:\\client-data\\load_rows.trace' ONLY LOG UNIQUE

see details regarding "MESSAGE LOG ROW log" Load options in Load table statement

LOAD TABLE Statement

Regards,

Tayeb.