Variable

cursor, record variable

This is an Oracle PLSQL.

DECLARE
    p_run_ind VARCHAR2;
    TYPE acbal_cv IS REF CURSOR;
    rec_dal_acbal T_DAL_ACBAL%ROWTYPE;
BEGIN

IF p_run_ind = 'STEP1' THEN
    OPEN acbal_cv FOR 
        SELECT product_type_code,product_code FROM T_DAL_ACBAL
            WHERE AC_CODE > ' ' AND UPDT_FLG != '0'
            AND UPDAT_FLG != '3' AND ROWNUM < 150001;

ELSIF p_run_ind = 'STEP2' THEN
    OPEN acbal_cv FOR 
        SELECT product_type_code,product_code FROM T_DAL_ACBAL
            WHERE AC_CODE > ' ' AND UPDT_FLG != '0'
            AND UPDAT_FLG != '3';

END IF;

LOOP
    FETCH acbal_cv INTO rec_dal_acbal;
    EXIT WHEN cur_stclerk%NOTFOUND;

    UPDATE T_AC_MSTR
    SET prd_type_code = rec_dal_acbal.product_type_code,
        prd_code = rec_dal_acbal.product_code
    ;

END LOOP;

COMMIT;
END;

dataflow in xml

<variable id="2" name="acbal_cv" type="variable" subType="cursor" coordinate="[9,7,0],[9,15,0]">
    <column id="14" name="*" coordinate="[1,1,0],[1,2,0]"/>
    <column id="14_0" name="PRODUCT_TYPE_CODE" coordinate="[1,1,0],[1,2,0]"/>
    <column id="14_1" name="PRODUCT_CODE" coordinate="[1,1,0],[1,2,0]"/>
</variable>
<variable id="25" name="rec_dal_acbal" type="variable" subType="record" coordinate="[23,22,0],[23,35,0]">
    <column id="26" name="*" coordinate="[1,1,0],[1,2,0]"/>
    <column id="26_0" name="PRODUCT_TYPE_CODE" coordinate="[1,1,0],[1,2,0]"/>
    <column id="26_1" name="PRODUCT_CODE" coordinate="[1,1,0],[1,2,0]"/>
</variable>

diagram

scalar variable

This is a Teradata stored procedure

CREATE PROCEDURE NewProc (IN id CHAR(12),
IN pname INTEGER,
IN pid INTEGER,
OUT dname CHAR(10))
BEGIN

    SELECT AGMT_ID
    INTO dname FROM MY_EPRD2_VR_BASE.AGMT
    WHERE PROCESS_ID = pid;
END;

dataflow in xml

<variable id="14" name="dname" type="variable" subType="scalar" coordinate="[8,7,0],[8,12,0]">
    <column id="15" name="dname" coordinate="[8,7,0],[8,12,0]"/>
</variable>

diagram