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
`@NotNull MergeNotMatchedSetStep<R>`	`whenNotMatchedThenInsert()`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement.
`@NotNull MergeNotMatchedValuesStepN<R>`	`whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)`	Add the `WHEN MATCHED THEN UPDATE` clause to the `MERGE` statement
`@NotNull MergeNotMatchedValuesStepN<R>`	`whenNotMatchedThenInsert(Field<?>... fields)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1> @NotNull MergeNotMatchedValuesStep1<R,T1>`	`whenNotMatchedThenInsert(Field<T1> field1)`	Add the `WHEN NOT MATCHED THEN INSERT` clause to the `MERGE` statement
`<T1,T2> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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> @NotNull 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