SAP ABAP Class CL_DB2_UTILS (Utilities for Operations)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Properties

Class	CL_DB2_UTILS
Short Description	Utilities for Operations
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU2	CCMS for DB2 for OS/390
Created	20090203	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_DB2_UTILS has no interface implemented.

Friends

Class CL_DB2_UTILS has no friend class.

Attributes

Class CL_DB2_UTILS has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_RFC	Static method	Public	Method	Checks if dbcon und RFC dest accesses to the same DB2 schema	20110620
2	CONVERT_BOOL_TO_STRING	Static method	Public	Method	Returns an abap_bool to string with true or false	20111122
3	CONVERT_FROM_DB2RAW	Static method	Public	Method		20100107
4	CONVERT_JULIAN_TO_ISO_DATE	Static method	Public	Method	converts a date ([yy]yyddd) into yyyymmdd	20120605
5	FORMAT_NUMBER	Static method	Public	Method		20090728
6	FORMAT_STRING	Static method	Public	Method	format string in order to display it in a table	20090217
7	GET_CONFIGURED_SYSTEMS	Static method	Public	Method	Get DB2 systems configured in the DBA Cockpit	20111230
8	INVERT_ABAP_BOOL	Static method	Public	Method	this methods inverts a given abap_bool value	20111130
9	IS_ABAP_SYSTEM	Static method	Public	Method	Does remote_dbcon point to a ABAP system	20110712
10	SAFE_DIVIDE	Static method	Public	Method	Division without ShortDumps	20100312
11	SET_ICON	Static method	Public	Method		20090309

Events

Class CL_DB2_UTILS has no event.

Types

Class CL_DB2_UTILS has no local type.

Method Signatures

Method CHECK_RFC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110620

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20110620
2	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20110620

Method CONVERT_BOOL_TO_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BOOL_VALUE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		to be translated	20111122
2	Returning	FORMATTED_STRING	Value transfer	☐	Type reference (TYPE)	STRING		ready translated string	20111122

Method CONVERT_BOOL_TO_STRING on class CL_DB2_UTILS has no exception.

Method CONVERT_FROM_DB2RAW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DB2_CCSID	Call by reference	☑	Type reference (TYPE)	I			20100107
2	Importing	DB2_TYPE	Call by reference	☐	Type reference (TYPE)	DB2COLTYPE		Column type specified in the column definition	20100107
3	Importing	HEX_VAL	Call by reference	☐	Type reference (TYPE)	XSTRING			20100107
4	Returning	STRING_VAL	Value transfer	☐	Type reference (TYPE)	STRING			20100107

Method CONVERT_FROM_DB2RAW on class CL_DB2_UTILS has no exception.

Method CONVERT_JULIAN_TO_ISO_DATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ABAP_DATE	Value transfer	☐	Type reference (TYPE)	DB2CHAR08		contains date like the following: YYYYMMDD	20120808
2	Importing	JULIAN_DATE	Call by reference	☐	Type reference (TYPE)	DB2CHAR08		year (2 or 4 digits) and day of year (3 digits):[YY]YYDDD	20120605

#	Exception	Resumable	Description	Created on
1	CX_DB2_ROOT	☐	DB2: root class regarding exceptions	20120606

Method FORMAT_NUMBER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DECIMALS	Call by reference	☑	Type reference (TYPE)	I		MS SQL int (obsolete - do not use)	20090728
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	STRING			20090728
3	Importing	STRING	Call by reference	☐	Type reference (TYPE)	STRING			20090728

Method FORMAT_NUMBER on class CL_DB2_UTILS has no exception.

Method FORMAT_STRING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DELTA	Call by reference	☐	Type reference (TYPE)	I			20090217
2	Importing	STM_STRING	Call by reference	☐	Type reference (TYPE)	STRING			20090217
3	Changing	STRING_TAB	Call by reference	☐	Type reference (TYPE)	STANDARD TABLE			20090217

Method FORMAT_STRING on class CL_DB2_UTILS has no exception.

Method GET_CONFIGURED_SYSTEMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CHECK_CONNECTIONS	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20111230
2	Importing	EXCLUDE_REMOTE_ABAPS	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20111230
3	Importing	ONLY_COMPLETE_ENTRIES	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20111230
4	Returning	SYSTEMS	Value transfer	☐	Type reference (TYPE)	DB2_SYSTEM_TAB		Table of System desciptors	20120122

Method GET_CONFIGURED_SYSTEMS on class CL_DB2_UTILS has no exception.

Method INVERT_ABAP_BOOL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	INVERTED	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL		Inverted value	20111130
2	Importing	TO_BE_INVERTED	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		Value to be inverted	20111130

Method INVERT_ABAP_BOOL on class CL_DB2_UTILS has no exception.

Method IS_ABAP_SYSTEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_ABAP_SYSTEM	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20110712
2	Importing	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20110712

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20110712

Method SAFE_DIVIDE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DENOMINATOR	Call by reference	☐	Type reference (TYPE)	ANY			20100312
2	Importing	NUMERATOR	Call by reference	☐	Type reference (TYPE)	ANY			20100312
3	Importing	PERCENT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20100312
4	Changing	RESULT	Call by reference	☐	Type reference (TYPE)	ANY			20100312

Method SAFE_DIVIDE on class CL_DB2_UTILS has no exception.

Method SET_ICON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	ICON	Call by reference	☐	Type reference (TYPE)	ICON_TEXT			20090309
2	Importing	NAME	Call by reference	☐	Type reference (TYPE)	STRING			20090309

Method SET_ICON on class CL_DB2_UTILS has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	703