org.jooq

Interface MergeUsingStep<R extends Record>

All Superinterfaces:

MergeKeyStepN<R>, MergeValuesStepN<R>

public interface MergeUsingStep<R extends Record>
extends MergeKeyStepN<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 and Description
MergeKeyStepN<R>	columns(Collection<? extends Field<?>> fields) Set the columns for merge (H2-specific syntax).
MergeKeyStepN<R>	columns(Field<?>... fields) Set the columns for merge (H2-specific syntax).
<T1> MergeKeyStep1<R,T1>	columns(Field<T1> field1) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2> MergeKeyStep2<R,T1,T2>	columns(Field<T1> field1, Field<T2> field2) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3> MergeKeyStep3<R,T1,T2,T3>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5> MergeKeyStep5<R,T1,T2,T3,T4,T5>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6> MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7> MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8> MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	columns(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) Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).
MergeOnStep<R>	using(TableLike<?> table) Add the USING clause to the SQL standard MERGE statement
MergeOnStep<R>	usingDual() Add a dummy USING clause to the SQL standard MERGE statement This results in USING(SELECT 1 FROM DUAL) for most RDBMS, or in USING(SELECT 1) AS [dummy_table(dummy_field)] in SQL Server, where derived tables need to be aliased.

Methods inherited from interface org.jooq.MergeKeyStepN

key, key

Methods inherited from interface org.jooq.MergeValuesStepN

select, values, values, values

Method Detail

using

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE})
MergeOnStep<R> using(TableLike<?> table)

Add the USING clause to the SQL standard MERGE statement

usingDual

@Support(value={CUBRID,DB2,FIREBIRD_3_0,HSQLDB,ORACLE,SQLSERVER,SYBASE})
MergeOnStep<R> usingDual()

Add a dummy USING clause to the SQL standard MERGE statement

This results in USING(SELECT 1 FROM DUAL) for most RDBMS, or in USING(SELECT 1) AS [dummy_table(dummy_field)] in SQL Server, where derived tables need to be aliased.

columns

@Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HSQLDB,MARIADB,MYSQL,ORACLE,SQLSERVER,SYBASE})
MergeKeyStepN<R> columns(Field<?>... fields)

Set the columns for merge (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	www.h2database.com/html/grammar.html#merge
HANA	HANA natively supports this syntax	http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/fc06a7751910149892c0d09be21a38/content.htm
PostgreSQL	This database can emulate the H2-specific MERGE statement via INSERT .. ON CONFLICT DO UPDATE	http://www.postgresql.org/docs/9.5/static/sql-insert.html
DB2, Firebird, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

columns

@Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HSQLDB,MARIADB,MYSQL,ORACLE,SQLSERVER,SYBASE})
MergeKeyStepN<R> columns(Collection<? extends Field<?>> fields)

Set the columns for merge (H2-specific syntax).

See Also:

columns(Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1> MergeKeyStep1<R,T1> columns(Field<T1> field1)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2> MergeKeyStep2<R,T1,T2> columns(Field<T1> field1,
                                                                                                                                                                                                                              Field<T2> field2)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3> MergeKeyStep3<R,T1,T2,T3> columns(Field<T1> field1,
                                                                                                                                                                                                                                    Field<T2> field2,
                                                                                                                                                                                                                                    Field<T3> field3)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4> MergeKeyStep4<R,T1,T2,T3,T4> columns(Field<T1> field1,
                                                                                                                                                                                                                                          Field<T2> field2,
                                                                                                                                                                                                                                          Field<T3> field3,
                                                                                                                                                                                                                                          Field<T4> field4)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5> MergeKeyStep5<R,T1,T2,T3,T4,T5> columns(Field<T1> field1,
                                                                                                                                                                                                                                                Field<T2> field2,
                                                                                                                                                                                                                                                Field<T3> field3,
                                                                                                                                                                                                                                                Field<T4> field4,
                                                                                                                                                                                                                                                Field<T5> field5)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6> MergeKeyStep6<R,T1,T2,T3,T4,T5,T6> columns(Field<T1> field1,
                                                                                                                                                                                                                                                      Field<T2> field2,
                                                                                                                                                                                                                                                      Field<T3> field3,
                                                                                                                                                                                                                                                      Field<T4> field4,
                                                                                                                                                                                                                                                      Field<T5> field5,
                                                                                                                                                                                                                                                      Field<T6> field6)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7> MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7> columns(Field<T1> field1,
                                                                                                                                                                                                                                                            Field<T2> field2,
                                                                                                                                                                                                                                                            Field<T3> field3,
                                                                                                                                                                                                                                                            Field<T4> field4,
                                                                                                                                                                                                                                                            Field<T5> field5,
                                                                                                                                                                                                                                                            Field<T6> field6,
                                                                                                                                                                                                                                                            Field<T7> field7)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8> MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> columns(Field<T1> field1,
                                                                                                                                                                                                                                                                  Field<T2> field2,
                                                                                                                                                                                                                                                                  Field<T3> field3,
                                                                                                                                                                                                                                                                  Field<T4> field4,
                                                                                                                                                                                                                                                                  Field<T5> field5,
                                                                                                                                                                                                                                                                  Field<T6> field6,
                                                                                                                                                                                                                                                                  Field<T7> field7,
                                                                                                                                                                                                                                                                  Field<T8> field8)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9> MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)

columns

@Generated(value="This method was generated using jOOQ-tools")
 @Support(value={CUBRID,DB2,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES_9_5,SQLSERVER,SYBASE})
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> columns(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)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

DSLContext.mergeInto(Table, Field...)