More options on the Load table in sybase IQ 15.4

[Former Member]

Hi,

During the loading of  1M rows into a table using the Load table - client file.

How can we handle, if row at 1000 does not  meet the data integrity and loading of that row fails.

Can we identify that row alone and continue the loading of rest of the records.

Is there a way to design such cases.

Thanks in advance for your help.

Thanks,

Swathi

[markmumy]

You should look at the ROW LOG and MESSAGE LOG options for LOAD TABLE.

   ... [ IGNORE CONSTRAINT constraint-type [, …] ] ... [ MESSAGE LOG ‘string’ ROW LOG ‘string’ [ ONLY LOG log-what [, …] ] ... [ LOG DELIMITED BY ‘string’ ] 

You can set the loader up to ignore constraint violations on the way in to IQ (check, unique, null, foreign key, and data value). With the ROW LOG and MESSAGE LOG options, you can decide to just throw away the data and not save it, or have it logged into the ROW LOG file for further processing and investigation.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01773.1604/doc/html/san12...

SyBooks Online

Mark

[markmumy]

I sent links for IQ 16, but the syntax is the same in IQ 15.4.

Mark