Advanced SAP Features

In this section:

This topic describes how to use security, BAPIs, joins, and tracing.


Top of page

x
Support for User Security

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:


Top of page

x
BAPI Support

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

Top of page

x
Join Support

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

iWay Software