PowerExchange for SAP NetWeaver User Guide for PowerCenter

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

Back Next

Generating Exec SQL

Exec SQL, or native SQL, is similar to standard SQL. Use the exec SQL option if the mapping contains only transparent tables or database views. The application server passes exec SQL requests directly to the database to execute. Exec SQL extracts data directly from the tables on the database server.

Although exec SQL can improve PowerCenter session performance, it may decrease performance of the SAP system. Extracting directly from the database may result in data inconsistencies due to application server buffering. Consult the SAP administrator before using the Exec SQL option.

The following sample shows an exec SQL statement:

exec sql [...]
  SELECT T685.MANDT, T685.KVEWE, T685.KAPPL, T685.KSCHL, T685.KOZGF, 
  T685.DATVO, T685.DTVOB
  INTO 
  :T685-MANDTT685-KVEWE, :T685-KAPPL, :T685-KSCHL, :T685-KOZGF, 
  :T685-DATVO, :T685-DTVOB
  FROM
  T685
  where [...]
endexec.

Exec SQL is not available for pool or cluster tables, hierarchies, or IDocs.

To select Exec SQL:

In the Application Source Qualifier, click the Properties tab.

Select Exec SQL.

Generating an ABAP Program

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal