MergeNotMatchedStep (jOOQ 3.11.12 API)

All Superinterfaces:: Attachable, AutoCloseable, Merge<R>, MergeFinalStep<R>, Query, QueryPart, Serializable, Statement

All Known Subinterfaces:: MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeOnConditionStep<R>

@Generated(value="This class was generated using jOOQ-tools")
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 and 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.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

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

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