SAP ABAP Class CL_PCO_DB_QUERY (PCo: Database Query)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-PCO (Application Component) Plant Connectivity (Pco): ABAP part
     ⤷ S_PCO (Package) Plant Connectivity: Business Suite Integration (ABAP Part)
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_PCO_QUERY PCo: Superclass for PCo Queries 20100721
2 Interface implementation (CLASS c. INTERFACES i_ref)  IF_PCO_DB_QUERY PCo: Methods for Database Query 20100721
Properties
Class CL_PCO_DB_QUERY  
Short Description PCo: Database Query    
Super Class CL_PCO_QUERY PCo: Superclass for PCo Queries 
Instantiability of a Class 1  Protected 
Final    
General Data
Message Class    
Program status     
Category 0   
Package S_PCO   Plant Connectivity: Business Suite Integration (ABAP Part) 
Created 20100721   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_PCO_DB_QUERY has no forward declaration.
Interfaces
# Interface Abstract Final Description Created on
1 IF_PCO_DB_QUERY PCo: Methods for Database Query 20100721
Friends
# Friend Modeled only Created on Description
1 CL_PCO_PAC 20100723 PCo: Object for Connection to PCo Agent
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 GC_TXT_COLUMN_NAME Constant Public Type reference (TYPE) STRING 'ColumnName' PCo: Text Element 'ColumnName' 20110714
2 GC_TXT_FROM Constant Public Type reference (TYPE) STRING 'FROM' PCo: Text Element 'FROM' 20110715
3 GC_TXT_INSERT_INTO Constant Public Type reference (TYPE) STRING 'INSERT INTO' PCo: Text Element 'INSERT INTO' 20110715
4 GC_TXT_NUMBER Constant Public Type reference (TYPE) STRING 'NUMBER' PCo: Text Element 'NUMBER' 20110721
5 GC_TXT_SELECT Constant Public Type reference (TYPE) STRING 'SELECT' PCo: Text Element 'SELECT' 20110715
6 GC_TXT_SET Constant Public Type reference (TYPE) STRING 'SET' PCo: Text Element 'SET' 20110715
7 GC_TXT_TABLE_NAME Constant Public Type reference (TYPE) STRING 'TableName' PCo: Text Element 'TableName' 20110714
8 GC_TXT_TEXT Constant Public Type reference (TYPE) STRING 'TEXT' PCo: Text Element 'TEXT' 20110718
9 GC_TXT_UPDATE Constant Public Type reference (TYPE) STRING 'UPDATE' PCo: Text Element 'UPDATE' 20110715
10 GC_TXT_VALUES Constant Public Type reference (TYPE) STRING 'VALUES' PCo: Text Element 'VALUES' 20110715
11 M_TEST_MODE Instance attribute Private Type reference (TYPE) BOOLE_D '' 'X' = Test Mode 20100917
Methods
# Method Level Visibility Method type Description Created on
1 BUILD_INSERT_DB_CONT Instance method Protected Method Generates Data String for Inserting Data (OLEDB) 20110715
2 BUILD_SELECT_DB_CONT Instance method Protected Method Generates Data String for Selecting Data (OLEDB) 20110715
3 BUILD_TAB_NAME_STRING Instance method Private Method Generates Data String for Selecting Data (OLEDB) 20110718
4 BUILD_UPDATE_DB_CONT Instance method Protected Method Generates Data String for Changing Data (OLEDB) 20110715
5 EXECUTE_DB_QUERY Instance method Public Method 20100723
6 GET_DB_TABLES Instance method Public Method 20100723
7 GET_DB_TAB_COLUMNS Instance method Public Method 20100723
8 HANDLE_GET_TABLES Instance method Protected Method Delivers Tables of an OLEDB Table Query 20110714
9 HANDLE_GET_TAB_COLUMNS Instance method Protected Method Delivers Table Columns of an OLEDB Table Query 20110714
10 HANDLE_SELECT_DB Instance method Protected Method Delivers Selected Data Records of an OLEDB Table Query 20110715
11 INSERT_DB_TAB_DATA Instance method Public Method 20110715
12 SELECT_DB_TAB_DATA Instance method Public Method 20110715
13 SET_VAL_IN_QUOTES Instance method Private Method Puts Text-Like Values in Double Quotation Marks 20110721
14 UPDATE_DB_TAB_DATA Instance method Public Method 20110715
Events
Class CL_PCO_DB_QUERY has no event.
Types
Class CL_PCO_DB_QUERY has no local type.
Method Signatures

Method BUILD_INSERT_DB_CONT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_CONTENT_STRING Call by reference Type reference (TYPE) STRING Datenstring für CDATA-Sektion des Query XMLs 20110715
2 Importing IT_PAR_VAL Call by reference Type reference (TYPE) PCO_T_DB_PAR_VAL Datensätze (Name/Wert), die in DB-Tabelle eingefügt werden 20110715
3 Importing IV_ADD_DB_TAB_CHAR Call by reference Type reference (TYPE) STRING Fügt zusätzliche Zeichen an Tabellennamen an 20110718
4 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110715
# Exception Resumable Description Created on
1 CX_PCO_BS_INT 20110715

Method BUILD_SELECT_DB_CONT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_CONTENT_STRING Call by reference Type reference (TYPE) STRING Datenstring für CDATA-Sektion des Query XMLs 20110715
2 Importing IT_SEL_COL Call by reference Type reference (TYPE) PCO_T_DB_PAR_VAL Spalten der DB-Tabelle, deren Inhalt ausgewählt wird 20110715
3 Importing IV_ADD_DB_TAB_CHAR Call by reference Type reference (TYPE) STRING Fügt zusätzliche Zeichen an Tabellennamen an 20110718
4 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110715
5 Importing IV_SEL_COND Call by reference Type reference (TYPE) STRING optionale Auswahlkriterien (WHERE-Clause) 20110715
# Exception Resumable Description Created on
1 CX_PCO_BS_INT 20110715

Method BUILD_TAB_NAME_STRING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_CONTENT_STRING Call by reference Type reference (TYPE) STRING Datenstring für CDATA-Sektion des Query XMLs 20110718
2 Importing IV_ADD_DB_TAB_CHAR Call by reference Type reference (TYPE) STRING Fügt zusätzliche Zeichen an Tabellennamen an 20110718
3 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110718
# Exception Resumable Description Created on
1 CX_PCO_BS_INT 20110718

Method BUILD_UPDATE_DB_CONT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_CONTENT_STRING Call by reference Type reference (TYPE) STRING Datenstring für CDATA-Sektion des Query XMLs 20110715
2 Importing IT_PAR_VAL Call by reference Type reference (TYPE) PCO_T_DB_PAR_VAL DB-Tabelleninhalte (Name/Wert), die geändert werden 20110715
3 Importing IV_ADD_DB_TAB_CHAR Call by reference Type reference (TYPE) STRING Fügt zusätzliche Zeichen an Tabellennamen an 20110718
4 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110715
5 Importing IV_UPDATE_COND Call by reference Type reference (TYPE) STRING Auswahlkriterien (WHERE-Clause) 20110715
# Exception Resumable Description Created on
1 CX_PCO_BS_INT 20110715

Method EXECUTE_DB_QUERY Signature

Method EXECUTE_DB_QUERY on class CL_PCO_DB_QUERY has no parameter.
Method EXECUTE_DB_QUERY on class CL_PCO_DB_QUERY has no exception.

Method GET_DB_TABLES Signature

Method GET_DB_TABLES on class CL_PCO_DB_QUERY has no parameter.
Method GET_DB_TABLES on class CL_PCO_DB_QUERY has no exception.

Method GET_DB_TAB_COLUMNS Signature

Method GET_DB_TAB_COLUMNS on class CL_PCO_DB_QUERY has no parameter.
Method GET_DB_TAB_COLUMNS on class CL_PCO_DB_QUERY has no exception.

Method HANDLE_GET_TABLES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_DB_TAB_RESULT Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_DB_DATA PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) 20110714
2 Importing IT_CHAR_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_CHARVAL PCo: Query-Ergebniswerte im CHAR-Format 20110714
3 Importing IT_COLUMNS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_COLUMNS PCo: Tabellentyp Spalteninformation zu Query-Ergebnis 20110714
4 Importing IT_ROWS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_ROWS PCo: Tabelle mit Zeileninformation zu Query-Ergebnistabelle 20110714
# Exception Resumable Description Created on
1 CX_PCO_BS_INT PCo Suite Integration: Ausnahmeklasse 20110714

Method HANDLE_GET_TAB_COLUMNS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_DB_TAB_RESULT Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_DB_DATA PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) 20110714
2 Importing IT_CHAR_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_CHARVAL PCo: Query-Ergebniswerte im CHAR-Format 20110714
3 Importing IT_COLUMNS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_COLUMNS PCo: Tabellentyp Spalteninformation zu Query-Ergebnis 20110714
4 Importing IT_ROWS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_ROWS PCo: Tabelle mit Zeileninformation zu Query-Ergebnistabelle 20110714
5 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110714
6 Importing IV_DB_TAB_TSET Call by reference Type reference (TYPE) INT4 Tabellensatznummer für Tabellenname 20110714
# Exception Resumable Description Created on
1 CX_PCO_BS_INT PCo Suite Integration: Ausnahmeklasse 20110714

Method HANDLE_SELECT_DB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_DB_TAB_RESULT Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_DB_DATA PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) 20110715
2 Importing IT_BOOL_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_BOOLVAL PCo: Query-Ergebniswerte im Boolean-Format 20110715
3 Importing IT_CHAR_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_CHARVAL PCo: Query-Ergebniswerte im CHAR-Format 20110715
4 Importing IT_COLUMNS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_COLUMNS PCo: Tabellentyp Spalteninformation zu Query-Ergebnis 20110715
5 Importing IT_DEC_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_DECVAL PCo: Tabellentyp für Query-Ergebniswerte im DEC-Format 20110715
6 Importing IT_FLOAT_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_FLOATVAL PCo: Tabellentyp für Query-Ergebniswerte im Float-Format 20110715
7 Importing IT_INT_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_INTVAL PCo: Tabellentyp für Query-Ergebniswerte im INT4-Format 20110715
8 Importing IT_ROWS Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_ROWS PCo: Tabelle mit Zeileninformation zu Query-Ergebnistabelle 20110715
9 Importing IT_TIMEST_VAL Call by reference Type reference (TYPE) PCO_T_QUERY_RESULT_TIMESTVAL PCo: Tabellentyp Query-Ergebniswerte im TIMESTAMPL-Format 20110715
10 Importing IV_DB_TAB_NAME Call by reference Type reference (TYPE) S_PCO_DB_TAB_NAME PCo: Name Datenbanktabelle 20110715
11 Importing IV_DB_TAB_TSET Call by reference Type reference (TYPE) INT4 Tabellensatznummer für Tabellenname 20110715
# Exception Resumable Description Created on
1 CX_PCO_BS_INT 20110715

Method INSERT_DB_TAB_DATA Signature

Method INSERT_DB_TAB_DATA on class CL_PCO_DB_QUERY has no parameter.
Method INSERT_DB_TAB_DATA on class CL_PCO_DB_QUERY has no exception.

Method SELECT_DB_TAB_DATA Signature

Method SELECT_DB_TAB_DATA on class CL_PCO_DB_QUERY has no parameter.
Method SELECT_DB_TAB_DATA on class CL_PCO_DB_QUERY has no exception.

Method SET_VAL_IN_QUOTES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CV_VAL_S Call by reference Type reference (TYPE) S_PCO_VALUE_STRING Wert im String-Format 20110721

Method SET_VAL_IN_QUOTES on class CL_PCO_DB_QUERY has no exception.

Method UPDATE_DB_TAB_DATA Signature

Method UPDATE_DB_TAB_DATA on class CL_PCO_DB_QUERY has no parameter.
Method UPDATE_DB_TAB_DATA on class CL_PCO_DB_QUERY has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 703