SAP Function Modules

comments icon Comments

CCDSNU_CALL_DSNUTILS SAP Function module - Calls DSNUTILS (DB2 Stored Procedure) for single utility execution







CCDSNU_CALL_DSNUTILS is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name CCDSNU_CALL_DSNUTILS into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: S_CCDSNU_DB2
Released Date: Not Released
Processing type: Normal fucntion module
Normal function module settings


Pattern for FM CCDSNU_CALL_DSNUTILS - CCDSNU CALL DSNUTILS 





CALL FUNCTION 'CCDSNU_CALL_DSNUTILS' "Calls DSNUTILS (DB2 Stored Procedure) for single utility execution
* EXPORTING
*   remote_dbcon =              " dbcon_name    Logical name for a database connection
  TABLES
    sysprint =                  " db2sysprnt    DB2/390: Structure of table SYSIBM.SYSPRINT
  CHANGING
    proc_area =                 " db2dsnup      Control Center stored procedures parameters
  EXCEPTIONS
    ERROR_IN_CHECK_VERSION = 1  "               Error in Function DBSYCHK_COMPARE_VERSION
    LESS_THAN_V6 = 2            "               The DB version is less than V6.1 => DSNUTILS is not available
    STOPROC_ABORTED = 3         "               Call of stored procedure didn't work
    DSNUTILS_NOT_INSTALLED = 4  "               DSNUTILS is not found in SYSIBM.SYSROUTINES
    CREATE_DATABASE_FAILED = 5  "               Creation of TEMP database or tablespace failed.
    NO_INPUT_TABLES = 6         "               The required global temp tables are not installed.
    SQL_ERROR = 7               "               EXEC SQL resulted in error.
    .  "  CCDSNU_CALL_DSNUTILS

ABAP code example for Function Module CCDSNU_CALL_DSNUTILS





The ABAP code below is a full code listing to execute function module CCDSNU_CALL_DSNUTILS including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).

DATA:
it_sysprint    TYPE STANDARD TABLE OF DB2SYSPRNT,"TABLES PARAM
wa_sysprint  LIKE LINE OF it_sysprint
.




DATA(ld_proc_area) = 'Check type of data required'.

DATA(ld_remote_dbcon) = 'Check type of data required'.
 

"populate fields of struture and append to itab
append wa_sysprint to it_sysprint.
.

CALL FUNCTION 'CCDSNU_CALL_DSNUTILS'
* EXPORTING
*   remote_dbcon =               ld_remote_dbcon
  TABLES
    sysprint =                   it_sysprint
  CHANGING
    proc_area =                  ld_proc_area
  EXCEPTIONS
    ERROR_IN_CHECK_VERSION =     1
    LESS_THAN_V6 =               2
    STOPROC_ABORTED =            3
    DSNUTILS_NOT_INSTALLED =     4
    CREATE_DATABASE_FAILED =     5
    NO_INPUT_TABLES =            6
    SQL_ERROR =                  7
    .  "  CCDSNU_CALL_DSNUTILS

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 2. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 3. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 4. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 5. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 6. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 7. "Exception
  "Add code for exception here
ENDIF.







ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:


ld_proc_area  TYPE DB2DSNUP ,
ld_remote_dbcon  TYPE DBCON_NAME ,
it_sysprint  TYPE STANDARD TABLE OF DB2SYSPRNT ,
wa_sysprint  LIKE LINE OF it_sysprint.




ld_proc_area = 'Check type of data required'.
ld_remote_dbcon = 'Check type of data required'. 

"populate fields of struture and append to itab
append wa_sysprint to it_sysprint.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name CCDSNU_CALL_DSNUTILS or its description.


   
 

CCDSNU_CALL_DSNUTILS - Calls DSNUTILS (DB2 Stored Procedure) for single utility execution
CCDSNU_CALL_DSNACCSS - Calls DSNACCSS to retrieve the DB2 subsystem name
CCDSNU_CALL_DSNACCSI - Calls DSNACCSI to retrieve the DB2 system's host name
CCDSNU_CALL_DSNACCOX - Calls DB2 stored procedure DSNACCOX
CCDSNU_CALL_DSNACCOR - Calls DSNACCOR (DB2 V7 Stored Procedure), all parameters may be change
CCDSNU_CALL_DSNACCMO - Calls DSNACCMO (DB2 V7 Stored Procedure) for utility schedule