Class SqlMergeUsingStep


public final class SqlMergeUsingStep extends MergeUsingStep<Row,SqlMergeUpdateStep,MergeInsertStep>
Step to specify the table to use for a USING clause in a MERGE statement.
  • Constructor Details

    • SqlMergeUsingStep

      public SqlMergeUsingStep(String targetTable, LitebridgeContext litebridgeContext)
      Creates a new SqlMergeUsingStep instance.
      Parameters:
      targetTable - the merge target table
      litebridgeContext - the Litebridge context
  • Method Details

    • using

      public SqlMergeOnStep using(String usingTableName)
      Sets the USING table for the merge operation.
      Parameters:
      usingTableName - name of the table to use for the USING clause
      Returns:
      step to specify the ON condition
    • using

      public SqlMergeOnStep using(Function<SelectApi,SelectTerminal<?>> subselect)
      Specifies a subquery to use as the merge source.
      Parameters:
      subselect - function building the subquery
      Returns:
      the merge ON condition clause terminal
    • using

      public SqlMergeOnStep using(FromTargetSpec fromTargetSpec)