Skip to content

/AWS1/CL_QSTJOINOPERATION

A transform operation that combines data from two sources based on specified join conditions.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_alias TYPE /AWS1/QSTXFRMOPERATIONALIAS /AWS1/QSTXFRMOPERATIONALIAS

Alias for this operation.

io_leftoperand TYPE REF TO /AWS1/CL_QSTXFRMOPSOURCE /AWS1/CL_QSTXFRMOPSOURCE

The left operand for the join operation.

io_rightoperand TYPE REF TO /AWS1/CL_QSTXFRMOPSOURCE /AWS1/CL_QSTXFRMOPSOURCE

The right operand for the join operation.

iv_type TYPE /AWS1/QSTJOINOPERATIONTYPE /AWS1/QSTJOINOPERATIONTYPE

The type of join to perform, such as INNER, LEFT, RIGHT, or OUTER.

iv_onclause TYPE /AWS1/QSTJOINOPERATIONONCLAUSE /AWS1/QSTJOINOPERATIONONCLAUSE

The join condition that specifies how to match rows between the left and right operands.

Optional arguments:

io_leftoperandproperties TYPE REF TO /AWS1/CL_QSTJOINOPERANDPROPS /AWS1/CL_QSTJOINOPERANDPROPS

Properties that control how the left operand's columns are handled in the join result.

io_rightoperandproperties TYPE REF TO /AWS1/CL_QSTJOINOPERANDPROPS /AWS1/CL_QSTJOINOPERANDPROPS

Properties that control how the right operand's columns are handled in the join result.


Queryable Attributes

Alias

Alias for this operation.

Accessible with the following methods

Method Description
GET_ALIAS() Getter for ALIAS, with configurable default
ASK_ALIAS() Getter for ALIAS w/ exceptions if field has no value
HAS_ALIAS() Determine if ALIAS has a value

LeftOperand

The left operand for the join operation.

Accessible with the following methods

Method Description
GET_LEFTOPERAND() Getter for LEFTOPERAND

RightOperand

The right operand for the join operation.

Accessible with the following methods

Method Description
GET_RIGHTOPERAND() Getter for RIGHTOPERAND

Type

The type of join to perform, such as INNER, LEFT, RIGHT, or OUTER.

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 condition that specifies how to match rows between the left and right operands.

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

LeftOperandProperties

Properties that control how the left operand's columns are handled in the join result.

Accessible with the following methods

Method Description
GET_LEFTOPERANDPROPERTIES() Getter for LEFTOPERANDPROPERTIES

RightOperandProperties

Properties that control how the right operand's columns are handled in the join result.

Accessible with the following methods

Method Description
GET_RIGHTOPERANDPROPERTIES() Getter for RIGHTOPERANDPROPERTIES