PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Rules for Inserting the ABAP Code Block

Generally, you can create a new ABAP code block and insert it before the first source table or after the last source table in the program flow. If you use a nested loop to join tables, you can also insert an ABAP code block between source tables. The SQL generation mode you select in the Application Source Qualifier determines the position you can insert the ABAP code block in the program flow.

The following table lists the rules for inserting an ABAP code block:

Generation Mode	Rules
Exec SQL	You can insert code blocks before the first source or after the last source. You cannot insert code blocks between sources in the program flow. If you insert a code block before the first source, the Designer inserts the code block before the exec statement. If you insert a code block after the last source, the Designer inserts the code block after the FORM WRITE_DSQNAME_TO_FILE statement.
ABAP join syntax	You can insert code blocks before the first source or after the last source. You cannot insert code blocks between sources in the program flow. If you insert a code block before the first source, the Designer inserts the code block before the select statement. If you insert a code block after the last source, the Designer inserts the code block after the where clause.
Open SQL (nested loop)	You can insert code blocks between sources in the program flow. The Designer inserts code blocks between the select statements. You can insert code blocks before the first source or after the last source. If you insert a code block before the first source, the Designer inserts the code block before the first select statement. If you insert a code block after the last source, the Designer inserts the code block after the last where clause.