IBM InfoSphere Information Server Pack for SAP R/3, Version 6.5.0.1 IBM InfoSphere Information Server Pack for SAP R/3, Version 6.5.0.1You can define the data to be extracted by constructing a SQL query.
The SQL Builder interface is the same as for other stages, for example, the Oracle Call Interface stage.
If you select Build SQL Query as the Generation Method on the Output ABAP Program page and click Build , the Build Open SQL Query dialog opens with the Tables page on top.
The Build Open SQL Query dialog contains the Tables (the default), Select, Where, Having, Order By, and SQL pages.
The generated SQL is customized to match the specific SQL syntax of the source database and conforms to the SAP proprietary Open SQL syntax used by ABAP programs.
The first five pages of the Build Open SQL Query dialog correspond to a clause in the generated SQL. The SQL page shows the complete SQL statement as determined by the settings in the preceding pages.
This topic is also in the IBM InfoSphere Information Server Integration Guide for IBM InfoSphere Information Server Pack for SAP R/3.
