You can create a subfunction to insert specific processing
in the SQL clauses WHENEVER and DECLARE CURSOR.
These clauses have a 10 hierarchical level.
- SQL statements
- Indicate the statement in which the specific processing is to
be inserted:
- WHENEVER SQL statement: This specific processing
is identified by REF=SQLW in the Macro code.
- DECLARE CURSOR SQL statement: If you select
this statement, you must indicate the Table type
Segment or the SQL view that contains the specific code to be taken
into account. This specific processing is identified by REF=SQLD
segm (where segm is the selected Segment
or SQL view) in the Macro code.
- Action type
- Specific processing is inserted in a Business
Component relatively to the standard generated processing. You can
then benefit from the generated processing and adapt it to your needs.
You
must select one of the following values to insert the specific processing:
- Insert before a standard processing.
The specific processing is inserted before the start tag of the standard
processing. The positioning of this specific processing is identified
by ACTION=*A in the Macro code.
- Insert after a standard processing.
The specific processing is inserted before the end tag if the hierarchical
level is greater than the level of the standard processing. It is
generated after the end tag if the hierarchical level is identical
to the level of the standard processing. The positioning of this specific
processing is identified by ACTION=*P in the Macro
code.
- Replace a standard processing. The
positioning of this specific processing is identified by ACTION=*R in
the Macro code.