Skip to content

/AWS1/CL_QSTJOININSTRUCTION

The instructions associated with a join.

CONSTRUCTOR

IMPORTING

Required arguments:

IV_LEFTOPERAND TYPE /AWS1/QSTLOGICALTABLEID /AWS1/QSTLOGICALTABLEID

The operand on the left side of a join.

IV_RIGHTOPERAND TYPE /AWS1/QSTLOGICALTABLEID /AWS1/QSTLOGICALTABLEID

The operand on the right side of a join.

IV_TYPE TYPE /AWS1/QSTJOINTYPE /AWS1/QSTJOINTYPE

The type of join that it is.

IV_ONCLAUSE TYPE /AWS1/QSTONCLAUSE /AWS1/QSTONCLAUSE

The join instructions provided in the ON clause of a join.

Optional arguments:

IO_LEFTJOINKEYPROPERTIES TYPE REF TO /AWS1/CL_QSTJOINKEYPROPERTIES /AWS1/CL_QSTJOINKEYPROPERTIES

Join key properties of the left operand.

IO_RIGHTJOINKEYPROPERTIES TYPE REF TO /AWS1/CL_QSTJOINKEYPROPERTIES /AWS1/CL_QSTJOINKEYPROPERTIES

Join key properties of the right operand.


Queryable Attributes

LeftOperand

The operand on the left side of a join.

Accessible with the following methods

Method Description
GET_LEFTOPERAND() Getter for LEFTOPERAND, with configurable default
ASK_LEFTOPERAND() Getter for LEFTOPERAND w/ exceptions if field has no value
HAS_LEFTOPERAND() Determine if LEFTOPERAND has a value

RightOperand

The operand on the right side of a join.

Accessible with the following methods

Method Description
GET_RIGHTOPERAND() Getter for RIGHTOPERAND, with configurable default
ASK_RIGHTOPERAND() Getter for RIGHTOPERAND w/ exceptions if field has no value
HAS_RIGHTOPERAND() Determine if RIGHTOPERAND has a value

LeftJoinKeyProperties

Join key properties of the left operand.

Accessible with the following methods

Method Description
GET_LEFTJOINKEYPROPERTIES() Getter for LEFTJOINKEYPROPERTIES

RightJoinKeyProperties

Join key properties of the right operand.

Accessible with the following methods

Method Description
GET_RIGHTJOINKEYPROPERTIES() Getter for RIGHTJOINKEYPROPERTIES

Type

The type of join that it is.

Accessible with the following methods

Method Description
GET_TYPE() Getter for TYPE, with configurable default
ASK_TYPE() Getter for TYPE w/ exceptions if field has no value
HAS_TYPE() Determine if TYPE has a value

OnClause

The join instructions provided in the ON clause of a join.

Accessible with the following methods

Method Description
GET_ONCLAUSE() Getter for ONCLAUSE, with configurable default
ASK_ONCLAUSE() Getter for ONCLAUSE w/ exceptions if field has no value
HAS_ONCLAUSE() Determine if ONCLAUSE has a value