Show TOC

Parameters for the SQLScript ProceduresLocate this document in the navigation structure

All SQLScript procedures for the implementation of methods to check and derive characteristic relationships or to protect data slices require an IN table parameter and an OUT table parameter with the structure of the modeled characteristic relationship or data slice. The IN parameter table contains all data records to be processed in the implementation. The OUT parameter table returns the processed data records.

Characteristic Relationships
  • CHECK
    • IN: All data records that should be processed by the procedure.
    • OUT: All data records in the IN parameter table, which are considered valid with regard to the characteristic relationship.
  • DERIVE
    • IN: All data records that should be processed by the procedure.
    • OUT: All data records in the IN parameter table, which are considered valid with regard to the characteristic relationshipm with derivation of target charactersitic values from the source characteristics.
  • CREATE
    • OUT: For the CREATE procedure, there is an OUT table parameter with the structure of the modeled characteristic relationship, containing all characteristic combinations that are valid according to the selection condition passed on to this method.
Data Slices
  • PROTECTED
    • IN: All data records that should be processed by the procedure.
    • OUT: All data records in the IN parameter table, which are protected against changes with regard to the data slice.

For all methods, the following applies:

If a DDIC structure of method GET_SQLSCRIPT_INFO is returned in parameter E_PARAMETER_NAME, the SQLScript procedure must have additional scalar parameters. The names of these parameters correspond to the component names of the DDIC structure.