Top Description Methods
org.jooq

public Interface MergeNotMatchedStep<R extends org.jooq.Record>

extends MergeFinalStep<R extends Record>
Known Direct Subinterfaces
org.jooq.MergeMatchedStep
Static Imports
org.jooq.SQLDialect.*

Deprecated

as a consequence of MergeFinalStep being deprecated. See corresponding docs for further information.

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

Modifier and TypeMethod and Description
public @NotNull MergeNotMatchedSetStep<R>
whenNotMatchedThenInsert()

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement.

public <T1> @NotNull MergeNotMatchedValuesStep1<R, T1>
whenNotMatchedThenInsert(Field<T1> field1)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <T1, T2> @NotNull MergeNotMatchedValuesStep2<R, T1, T2>
whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <T1, T2, T3> @NotNull MergeNotMatchedValuesStep3<R, T1, T2, T3>
whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <T1, T2, T3, T4> @NotNull MergeNotMatchedValuesStep4<R, T1, T2, T3, T4>
whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public <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)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public @NotNull MergeNotMatchedValuesStepN<R>
whenNotMatchedThenInsert(Field<?>... fields)

Deprecated as a consequence of Field being deprecated.
Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
public @NotNull MergeNotMatchedValuesStepN<R>
whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)

Add the WHEN MATCHED THEN UPDATE clause to the MERGE statement

Method Detail

whenNotMatchedThenInsertback to summary
public @NotNull MergeNotMatchedSetStep<R> whenNotMatchedThenInsert()

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement.

Unlike the whenNotMatchedThenInsert(Field...) and whenNotMatchedThenInsert(Collection) methods, this will give access to a MySQL-like API allowing for INSERT SET a = x, b = y syntax.

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <T1> @NotNull MergeNotMatchedValuesStep1<R, T1> whenNotMatchedThenInsert(Field<T1> field1)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <T1, T2> @NotNull MergeNotMatchedValuesStep2<R, T1, T2> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <T1, T2, T3> @NotNull MergeNotMatchedValuesStep3<R, T1, T2, T3> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <T1, T2, T3, T4> @NotNull MergeNotMatchedValuesStep4<R, T1, T2, T3, T4> whenNotMatchedThenInsert(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public <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)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public @NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Field<?>... fields)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES
whenNotMatchedThenInsertback to summary
public @NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)

Add the WHEN MATCHED THEN UPDATE clause to the MERGE statement

Annotations
@NotNull
@CheckReturnValue
@Support:CUBRID, DERBY, FIREBIRD, H2, HSQLDB, POSTGRES