org.eclipse.datatools.modelbase.sql.query
Interface QueryMergeStatement
- All Superinterfaces:
- org.eclipse.emf.ecore.EModelElement, org.eclipse.emf.ecore.ENamedElement, org.eclipse.emf.ecore.EObject, org.eclipse.emf.common.notify.Notifier, QueryChangeStatement, QueryStatement, SQLDataChangeStatement, SQLDataStatement, SQLObject, SQLQueryObject, SQLStatement
public interface QueryMergeStatement
- extends QueryChangeStatement
A representation of the model object 'SQL Merge Statement'.
SQL syntax:
MERGE INTO [ [ AS] ]
USING
ON
where:
::=
[ ::=
|
Note: a non-syntactic rule is that the operation specification list can contain at most one update specification and one insert specification.
Example:
MERGE INTO inventory AS in
USING
(SELECT partno, description, count
FROM shipment
WHERE shipment.partno IS NOT NULL) AS sh
ON (in.partno = sh.partno)
WHEN MATCHED THEN
UPDATE SET
description = sh.description,
quantity = in.quantity + sh.count
WHEN NOT MATCHED THEN
INSERT (partno, description, quantity)
VALUES (sh.partno, sh.description, sh.count)
The following features are supported:
- See Also:
SQLQueryModelPackage.getQueryMergeStatement()
Methods inherited from interface org.eclipse.datatools.modelbase.sql.schema.SQLObject |
addEAnnotation, addEAnnotationDetail, getComments, getDependencies, getDescription, getEAnnotation, getEAnnotationDetail, getExtensions, getLabel, getPrivileges, removeEAnnotationDetail, setAnnotationDetail, setDescription, setLabel |
Methods inherited from interface org.eclipse.emf.ecore.ENamedElement |
getName, setName |
Methods inherited from interface org.eclipse.emf.ecore.EModelElement |
getEAnnotations |
Methods inherited from interface org.eclipse.emf.ecore.EObject |
eAllContents, eClass, eContainer, eContainingFeature, eContainmentFeature, eContents, eCrossReferences, eGet, eGet, eIsProxy, eIsSet, eResource, eSet, eUnset |
Methods inherited from interface org.eclipse.emf.common.notify.Notifier |
eAdapters, eDeliver, eNotify, eSetDeliver |
getTargetTable
MergeTargetTable getTargetTable()
- Returns the value of the 'Target Table' containment reference.
It is bidirectional and its opposite is '
Merge Statement
'.
If the meaning of the 'Target Table' containment reference isn't clear,
there really should be more of a description here...
- Returns:
- the value of the 'Target Table' containment reference.
- See Also:
setTargetTable(MergeTargetTable)
,
SQLQueryModelPackage.getQueryMergeStatement_TargetTable()
,
MergeTargetTable.getMergeStatement()
setTargetTable
void setTargetTable(MergeTargetTable value)
- Sets the value of the '
Target Table
' containment reference.
- Parameters:
value
- the new value of the 'Target Table' containment reference.- See Also:
getTargetTable()
getSourceTable
MergeSourceTable getSourceTable()
- Returns the value of the 'Source Table' containment reference.
It is bidirectional and its opposite is '
Merge Statement
'.
If the meaning of the 'Source Table' containment reference isn't clear,
there really should be more of a description here...
- Returns:
- the value of the 'Source Table' containment reference.
- See Also:
setSourceTable(MergeSourceTable)
,
SQLQueryModelPackage.getQueryMergeStatement_SourceTable()
,
MergeSourceTable.getMergeStatement()
setSourceTable
void setSourceTable(MergeSourceTable value)
- Sets the value of the '
Source Table
' containment reference.
- Parameters:
value
- the new value of the 'Source Table' containment reference.- See Also:
getSourceTable()
getOnCondition
MergeOnCondition getOnCondition()
- Returns the value of the 'On Condition' containment reference.
It is bidirectional and its opposite is '
Merge Statement
'.
If the meaning of the 'On Condition' containment reference isn't clear,
there really should be more of a description here...
- Returns:
- the value of the 'On Condition' containment reference.
- See Also:
setOnCondition(MergeOnCondition)
,
SQLQueryModelPackage.getQueryMergeStatement_OnCondition()
,
MergeOnCondition.getMergeStatement()
setOnCondition
void setOnCondition(MergeOnCondition value)
- Sets the value of the '
On Condition
' containment reference.
- Parameters:
value
- the new value of the 'On Condition' containment reference.- See Also:
getOnCondition()
getOperationSpecList
org.eclipse.emf.common.util.EList getOperationSpecList()
- Returns the value of the 'Operation Spec List' containment reference list.
The list contents are of type
MergeOperationSpecification
.
It is bidirectional and its opposite is 'Merge Statement
'.
If the meaning of the 'Operation Spec List' containment reference list isn't clear,
there really should be more of a description here...
- Returns:
- the value of the 'Operation Spec List' containment reference list.
- See Also:
SQLQueryModelPackage.getQueryMergeStatement_OperationSpecList()
,
MergeOperationSpecification.getMergeStatement()