Module org.jooq

Package org.jooq

Interface MergeNotMatchedStep<R extends Record>

All Superinterfaces:

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

All Known Subinterfaces:

MergeMatchedDeleteStep<R>, MergeMatchedSetMoreStep<R>, MergeMatchedStep<R>, MergeMatchedWhereStep<R>, MergeNotMatchedSetMoreStep<R>, MergeNotMatchedWhereStep<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

Modifier and Type	Method	Description
@NotNull MergeNotMatchedThenStep<R>	whenNotMatched()	Add the WHEN NOT MATCHED THEN INSERT clause to the MERGE statement
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(String sql)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(String sql, Object... bindings)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(String sql, QueryPart... parts)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(Condition condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(Field<Boolean> condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedAnd(SQL sql)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySource()	Add the WHEN NOT MATCHED BY SOURCE THEN INSERT clause to the MERGE statement
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(String sql)	Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(String sql, Object... bindings)	Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(String sql, QueryPart... parts)	Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(Condition condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(Field<Boolean> condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeMatchedThenStep<R>	whenNotMatchedBySourceAnd(SQL sql)	Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTarget()	Add the WHEN NOT MATCHED BY TARGET THEN INSERT clause to the MERGE statement
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(String sql)	Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(String sql, Object... bindings)	Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(String sql, QueryPart... parts)	Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(Condition condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(Field<Boolean> condition)	Add the WHEN NOT MATCHED AND clause to the MERGE statement.
@NotNull MergeNotMatchedThenStep<R>	whenNotMatchedByTargetAnd(SQL sql)	Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.
@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 NOT MATCHED THEN INSERT 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 org.jooq.AttachableQueryPart

getBindValues, getParam, getParams, getSQL, getSQL

Methods inherited from interface org.jooq.Publisher

subscribe

Methods inherited from interface org.reactivestreams.Publisher

subscribe

Methods inherited from interface org.jooq.Query

bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout

Methods inherited from interface org.jooq.QueryPart

$replace, $replace, $traverse, $traverse, equals, hashCode, toString

Method Details

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@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.

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<T1> @NotNull MergeNotMatchedValuesStep1<R,T1> whenNotMatchedThenInsert(Field<T1> field1)

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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Field<?>... fields)

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

whenNotMatchedThenInsert

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedValuesStepN<R> whenNotMatchedThenInsert(Collection<? extends Field<?>> fields)

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

whenNotMatched

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatched()

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

whenNotMatchedAnd

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(Condition condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedAnd

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(Field<Boolean> condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(SQL sql)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(SQL)
• SQL

whenNotMatchedAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(String sql)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String)
• SQL

whenNotMatchedAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(String sql,
 Object... bindings)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, Object...)
• DSL.sql(String, Object...)
• SQL

whenNotMatchedAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedAnd(String sql,
 QueryPart... parts)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, QueryPart...)
• DSL.sql(String, QueryPart...)
• SQL

whenNotMatchedBySource

@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySource()

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

whenNotMatchedBySourceAnd

@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(Condition condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedBySourceAnd

@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(Field<Boolean> condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedBySourceAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(SQL sql)

Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(SQL)
• SQL

whenNotMatchedBySourceAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(String sql)

Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String)
• SQL

whenNotMatchedBySourceAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(String sql,
 Object... bindings)

Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, Object...)
• DSL.sql(String, Object...)
• SQL

whenNotMatchedBySourceAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({POSTGRES_17,SQLSERVER})
@NotNull MergeMatchedThenStep<R> whenNotMatchedBySourceAnd(String sql,
 QueryPart... parts)

Add the WHEN NOT MATCHED BY SOURCE AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, QueryPart...)
• DSL.sql(String, QueryPart...)
• SQL

whenNotMatchedByTarget

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTarget()

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

whenNotMatchedByTargetAnd

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(Condition condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedByTargetAnd

@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(Field<Boolean> condition)

Add the WHEN NOT MATCHED AND clause to the MERGE statement.

whenNotMatchedByTargetAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(SQL sql)

Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(SQL)
• SQL

whenNotMatchedByTargetAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(String sql)

Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String)
• SQL

whenNotMatchedByTargetAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(String sql,
 Object... bindings)

Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, Object...)
• DSL.sql(String, Object...)
• SQL

whenNotMatchedByTargetAnd

@PlainSQL
@NotNull
@CheckReturnValue
@Support({CUBRID,DB2,DERBY,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,ORACLE,POSTGRES_15,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull MergeNotMatchedThenStep<R> whenNotMatchedByTargetAnd(String sql,
 QueryPart... parts)

Add the WHEN NOT MATCHED BY TARGET AND clause to the MERGE statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

See Also:

• DSL.condition(String, QueryPart...)
• DSL.sql(String, QueryPart...)
• SQL