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()