All Superinterfaces:

Attachable, AutoCloseable, Flow.Publisher<Integer>, Merge<R>, MergeFinalStep<R>, org.reactivestreams.Publisher<Integer>, Query, QueryPart, RowCountQuery, Serializable, Statement

All Known Subinterfaces:

MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeOnConditionStep<R>
```
public interface MergeNotMatchedStep<R extends Record>
extends MergeFinalStep<R>
```
This type is used for the Merge's DSL API.
Example:
```
 DSLContext create = DSL.using(configuration);

 create.mergeInto(table)
       .using(select)
       .on(condition)
       .whenMatchedThenUpdate()
       .set(field1, value1)
       .set(field2, value2)
       .whenNotMatchedThenInsert(field1, field2)
       .values(value1, value2)
       .execute();
 
```
Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`MergeNotMatchedSetStep<R>`	`whenNotMatchedThenInsert()`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement.
`MergeNotMatchedValuesStepN<R>`	`whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)`	Add the `WHEN MATCHED THEN UPDATE` clause to the `MERGE` statement
`MergeNotMatchedValuesStepN<R>`	`whenNotMatchedThenInsert(Field<?>... fields)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1> MergeNotMatchedValuesStep1<R,T1>`	`whenNotMatchedThenInsert(Field<T1> field1)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2> MergeNotMatchedValuesStep2<R,T1,T2>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3> MergeNotMatchedValuesStep3<R,T1,T2,T3>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4> MergeNotMatchedValuesStep4<R,T1,T2,T3,T4>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5> MergeNotMatchedValuesStep5<R,T1,T2,T3,T4,T5>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6> MergeNotMatchedValuesStep6<R,T1,T2,T3,T4,T5,T6>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7> MergeNotMatchedValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8> MergeNotMatchedValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeNotMatchedValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeNotMatchedValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeNotMatchedValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeNotMatchedValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeNotMatchedValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeNotMatchedValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeNotMatchedValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeNotMatchedValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeNotMatchedValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeNotMatchedValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeNotMatchedValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeNotMatchedValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeNotMatchedValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeNotMatchedValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>`	`whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement

Methods inherited from interface org.jooq.Attachable
attach, configuration, detach

Methods inherited from interface java.util.concurrent.Flow.Publisher
subscribe

Methods inherited from interface org.reactivestreams.Publisher
subscribe

Methods inherited from interface org.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString