CLASSIFY

Warning: This instruction is only applicable to views declared and used in the data flow.

Section for use

All

Syntax

CLASSIFY ViewName Parameter

Description

This instruction creates or updates a record in a file.

It must be used after the PLACE instruction.

The instruction will:

• • modify a record if the record exists,

  • create a record, if the record does not exist.
    Note: with ADELIA programs, records will only be created if the "Create record" attribute has been activated on the view.

Important: The STORE instruction is equivalent to PLACE + CLASSIFY.

The *MR parameter allows you to generate update and creation implicit management rules that are linked to the entity corresponding to the view, even if the program is generated without the option to generate implicit management rules.

The *NO_MR parameter allows you not to generate update and creation implicit management rules that are linked to the entity corresponding to the view, even if the program is generated with the option to generate implicit management rules.

Example

*******************

VALIDATION 02

*******************

ZORDER_DATE = &DATE6_FORMAT('MDY';'YMD';ZORDER_DATE)

PLACE ORDERS

*

ORDER_DATE = *DATE8

ORDER_USER = *USER

CLASSIFY ORDERS

*

MANAGE_SFL 2

PLACE ORDER_LINES

ORD_LIN_DATE = *DATE8

ORD_LIN_USER = *USER

CLASSIFY ORDER_LINES

END_MANAGE_SFL

↑ Top of page