In this section: |
This topic describes how to use security, BAPIs, joins, and tracing.
The Native interface for SAP has been enhanced to handle the user ID and password in the following syntax:
ENGINE SQLSAP SET CONNECTION_ATTRIBUTES system/user,password:'client'
This feature allows you to run a secured request that involves the following:
This release supports most read-only BAPIs, including joins, as described in the following example:
CREATE SYNONYM baseapp/BUS0002_GETLIST FOR BUS0002/GETLIST BAPI DBMS SQLSAP AT I46 END CREATE SYNONYM baseapp/BUS0002_GETDETAIL FOR BUS0002/GETDETAIL BAPI DBMS SQLSAP AT I46 END JOIN BAPI0002_COMP_CODE IN COMPANYCODE_GETLIST TO CCGD2_COMP_CODE IN OMPANYCODE_GETDETAIL END TABLE FILE COMPANYCODE_GETLIST PRINT CCGL0_TYPE NOPRINT BAPI0002_COMP_CODE BAPI0002_COMP_NAME CCGD2_CURRENCY CCGD2_LANGU IF BAPI0002_COMP_CODE NE '2300' OR '6000' END
The Native Interface supports all joins from and to SAP. For performance reasons, we do not recommend joining to an SAP data source from a non-SAP data source. It is more efficient to hold the keys in a sequential file, and then use the following code:
TABLE FILE SAP PRINT FIELDS IF KEYS IS (HOLD) END
WebFOCUS |