FOREACH - connect_cdc_sqdata - Latest

Category

Cursor Functions

Syntax

FOREACH(cursor_name [, value_1 [, value_2 ...]]) statement_body

Parameters and descriptions

Usage

• For cursor processing, FOREACH() is a compact alternative to explicit OPEN(), FETCH(), and CLOSE() logic.

  For best results:

  • The values supplied in FOREACH() should match the number and order of the fields in the cursor USING record.
  • The record named in the cursor DESCRIBED BY clause should match the number, order, and compatible types of the columns returned by the cursor.
  • The statement body should read the DESCRIBED BY fields populated by the current fetch.
• If the cursor reaches end-of-data, iteration ends normally. Any other open or fetch failure is treated as a runtime failure.

Example

CREATE RDBMS CURSOR AS SQDATA_RDBMS_CURSOR WITH
        /+
        SELECT ACCOUNT_ID, ACCOUNT_STATUS
        FROM SQDATA_LOOKUP_SOURCE
        WHERE ACCOUNT_ID = ? AND REGION_CODE = ?
        +/
        DESCRIBED BY SQDATA_CURSOR_ROW
        USING SQDATA_CURSOR_INPUT
        ;
        
        FOREACH(SQDATA_RDBMS_CURSOR, SQDATA_CURSOR_INPUT.ACCOUNT_ID, SQDATA_CURSOR_INPUT.REGION_CODE)
        DO
        TARGET_ACCOUNT_ID     = SQDATA_CURSOR_ROW.ACCOUNT_ID
        TARGET_ACCOUNT_STATUS = SQDATA_CURSOR_ROW.ACCOUNT_STATUS
        END