2

What is the alternative for Insert ignore in sybase IQ.

I want inserts to go through without failing in case of duplicates , and insert all the non-duplicates. The table has a unique key constraint on a column

Raks
  • 870
  • 3
  • 11
  • 27

1 Answers1

1

Try the on existing skip clause:

insert into mytable (col1, col2) 
   on existing skip 
   values ('a','b')
Graeme Perrow
  • 56,086
  • 21
  • 82
  • 121