Hierarchy
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Meta Relationship - Using
# | Relationship type | Using | Short Description | Created on |
---|---|---|---|---|
1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_ACTION_CONTROLLER | ORA: Abstract Action Controller | 20060308 |
Properties
Class | CL_ORA_ACTION_JSEL | |
Short Description | ORA: SQL Command Editor | |
Super Class | CL_ORA_ACTION_CONTROLLER | ORA: Abstract Action Controller |
Instantiability of a Class | 2 | Public |
Final |
General Data
Message Class | ||
Program status | ||
Category | 0 | |
Package | S_DBMON_ORA_COCKPIT | Database Monitor for Oracle in Cockpit Framework |
Created | 20050912 | SAP |
Last change | 20130531 | SAP |
Shared Memory-enabled | ||
Fixed point arithmetic | ||
Unicode checks active |
Forward declarations
# | Type group / Object type | Type | Type Description |
---|---|---|---|
1 | ORACC | Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class CL_ORA_ACTION_JSEL has no interface implemented.
Friends
Class CL_ORA_ACTION_JSEL has no friend class.
Attributes
# | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ALV_GRID_2 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_ALV_GRID | ALV Grid | 20081209 | ||
2 | CONTAINER_1 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for Editor Control | 20081209 | ||
3 | CONTAINER_2 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for Editor Control | 20081209 | ||
4 | GC_APSTR | Constant | Private | Type reference (TYPE) | CHAR1 | '''' | Single-Character Flag | 20051220 | |
5 | GC_BA_ABORT | Constant | Private | Type reference (TYPE) | CHAR1 | 3 | Abort Batch Scheduling | 20051228 | |
6 | GC_BA_REENTER | Constant | Private | Type reference (TYPE) | CHAR1 | 2 | Enter new parameter values | 20051228 | |
7 | GC_BA_RUNJOB | Constant | Private | Type reference (TYPE) | CHAR1 | 1 | Run Job | 20051228 | |
8 | GC_CTYPE_DBFIELD | Constant | Private | Type reference (TYPE) | DSQLPCOLTYPE | 1 | Column type "database field" | 20051220 | |
9 | GC_CTYPE_EXPR | Constant | Private | Type reference (TYPE) | DSQLPCOLTYPE | 2 | Column type "expression" | 20051220 | |
10 | GT_RESULT | Instance attribute | Private | Type reference (TYPE) | TT_RESULT | Global result table | 20081209 | ||
11 | G_BATCH_ACTION | Instance attribute | Private | Type reference (TYPE) | CHAR1 | Flag: Action after batch param. Popup | 20051228 | ||
12 | G_BATCH_LDATE | Instance attribute | Private | Type reference (TYPE) | BTCLSDATE | Latest Execution Date for a Background Job | 20051228 | ||
13 | G_BATCH_LTIME | Instance attribute | Private | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20051228 | ||
14 | G_BATCH_PRIMM | Instance attribute | Private | Type reference (TYPE) | PRIMM2 | Print Time | 20060113 | ||
15 | G_BATCH_PRINT_CONTENT | Instance attribute | Private | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060116 | ||
16 | G_BATCH_PRINT_RT_STAT | Instance attribute | Private | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060116 | ||
17 | G_BATCH_SDATE | Instance attribute | Private | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20051228 | ||
18 | G_BATCH_STIME | Instance attribute | Private | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20051228 | ||
19 | G_BATCH_STMTID | Instance attribute | Private | Type reference (TYPE) | ORA_JSEL_STMT_ID | ID for an oracle 'arbitrary join select monitor' statement | 20051228 | ||
20 | G_BATCH_XIMMED | Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20051228 | ||
21 | G_BATCH_XSTTIM | Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Batch execution at specified timestamp | 20051228 | ||
22 | G_CONTENT_NOT_ALLOWED | Instance attribute | Private | Type reference (TYPE) | XFELD | Display of query result not allowed | 20060117 | ||
23 | G_DBNAVSYST | Instance attribute | Private | Type reference (TYPE) | DB6NAVSYST | System Registration Table | 20051220 | ||
24 | G_REF_CONTAINER | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Reference to container (for editor) | 20051219 | ||
25 | G_REF_EDITOR | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_TEXTEDIT | Reference to editor | 20051219 | ||
26 | G_REF_SERVICES | Instance attribute | Public | Object reference (TYPE REF TO) | CL_ORA_SRV_JSEL | Reference to instance with service methods | 20060116 | ||
27 | G_REMOTE_SYSTEM | Instance attribute | Public | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20051219 | ||
28 | NAV_REF | Instance attribute | Private | Attribute reference (LIKE) | 20100812 | ||||
29 | VIEW_DATA | Instance attribute | Public | Type reference (TYPE) | ORACC_ACTION_JSEL | Data displayed | 20050912 |
Methods
# | Method | Level | Visibility | Method type | Description | Created on |
---|---|---|---|---|---|---|
1 | CHECK_TABLES_OWNER | Instance method | Private | Method | Check owner of tables that have to be read | 20051219 |
2 | CLOSE_ADBC_CONNECTION | Instance method | Private | Method | Close ADBC connection (incl handling of exception) | 20060118 |
3 | CREATE_ADBC_CONNECTION | Instance method | Private | Method | Create ADBC connection for use in different DB accesses | 20060118 |
4 | CREATE_SUBROUTINE_POOL | Instance method | Private | Method | Create and generate a subroutine pool containing the SQL | 20051219 |
5 | DISPLAY_PARSE_ERROR | Instance method | Private | Method | Display parse error message | 20051219 |
6 | DISPLAY_STATS | Instance method | Private | Method | Display statistics using ALV | 20060131 |
7 | FILL_VIEW_STRUCTURE | Instance method | Public | Method | Catch the request from the AWR Reporting Monitor | 20100812 |
8 | FREE_CONTROL_RESSOURCES | Instance method | Private | Method | Free all control ressources | 20051219 |
9 | GET_JOB_DEFAULT_PARAMS | Instance method | Public | Method | Get default values for job parameters of current statement | 20060118 |
10 | GET_MAX_ID_COUNT | Instance method | Public | Method | Get the max ID_COUNT for given ID of table ORA_SQLC_DATA | 20081209 |
11 | GET_ORASID_CURRENT_WP | Instance method | Private | Method | Get oracle SID for current SAP workprocess | 20060118 |
12 | GET_RESULT_TABLE | Instance method | Private | Method | Get the result of the SQL query from generated program | 20081209 |
13 | GET_SQL_STATEMENT | Instance method | Public | Method | Get SQL statement from editor | 20051219 |
14 | GET_TIME_STATS | Instance method | Private | Method | Get current runtime statistics information | 20060131 |
15 | OKCODE_CREATE_JOB | Instance method | Private | Method | Create a batch job for statement execution | 20060118 |
16 | OKCODE_DELE_STMT | Instance method | Private | Method | Delete SQL statement from database | 20051222 |
17 | OKCODE_LOAD_STMT | Instance method | Private | Method | Load SQL statement from database | 20051222 |
18 | OKCODE_MONITOR_HELP | Instance method | Private | Method | Display monitor help (call knowledge warehouse) | 20060301 |
19 | OKCODE_PARSE | Instance method | Public | Method | Parse the edited SQL statement | 20051219 |
20 | OKCODE_PARSE_AND_EXEC | Instance method | Public | Method | Parse and Execute the edited SQL statement | 20051219 |
21 | OKCODE_SAVE_STMT | Instance method | Private | Method | Save SQL statement to database | 20051222 |
22 | PARSE_SQL_STATEMENT | Instance method | Private | Method | Parse SQL statement,get result columns and tables to be read | 20051219 |
23 | SET_AND_CHECK_JOB_PARAMS | Instance method | Public | Method | Set attributes for job parameters and check them | 20051228 |
24 | SPLIT_UP_INPUT_STRING | Instance method | Public | Method | Determine the identifier for output table | 20081209 |
25 | SWITCH_TO_ENGLISH | Instance method | Private | Method | Switch to english if necessary | 20060201 |
Events
Class CL_ORA_ACTION_JSEL has no event.
Types
Class CL_ORA_ACTION_JSEL has no local type.
Method Signatures
Method CHECK_TABLES_OWNER Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20051219 | ||
2 | Importing | IT_TABLES | Call by reference | Type reference (TYPE) | TSQLPTABLES | Table: tables / views within a parsed sql statement | 20051219 |
Method CHECK_TABLES_OWNER on class CL_ORA_ACTION_JSEL has no exception.
Method CLOSE_ADBC_CONNECTION Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | I_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Reference to ADBC connection that has to be closed | 20060118 |
Method CLOSE_ADBC_CONNECTION on class CL_ORA_ACTION_JSEL has no exception.
Method CREATE_ADBC_CONNECTION Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Returning | R_CONNECTION | Value transfer | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Reference to created connection | 20060118 |
Method CREATE_ADBC_CONNECTION on class CL_ORA_ACTION_JSEL has no exception.
Method CREATE_SUBROUTINE_POOL Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | E_RC | Call by reference | Type reference (TYPE) | I | <> 0 if error occured | 20051219 | ||
2 | Exporting | E_SQL_REPORT | Call by reference | Type reference (TYPE) | PROGNAME | ABAP Program Name, generated report | 20051219 | ||
3 | Importing | IT_COLUMNS | Call by reference | Type reference (TYPE) | TSQLPCOL | list of columns to read in the statement | 20051219 | ||
4 | Importing | IT_TABLES | Call by reference | Type reference (TYPE) | TSQLPTABLES | list of tables used in the statement | 20051219 | ||
5 | Importing | I_SQL_STATEMENT | Call by reference | Type reference (TYPE) | STRING | SQL statement | 20051219 | ||
6 | Importing | P_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier of table ORA_SQLC_DATA | 20081209 | ||
7 | Importing | P_MAX_COUNT | Call by reference | Type reference (TYPE) | I | Max ID_COUNT for given ID of table ORA_SQLC_DATA | 20081209 |
Method CREATE_SUBROUTINE_POOL on class CL_ORA_ACTION_JSEL has no exception.
Method DISPLAY_PARSE_ERROR Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | I_SUBRC | Call by reference | Type reference (TYPE) | SYSUBRC | Returncode from parser | 20051219 |
Method DISPLAY_PARSE_ERROR on class CL_ORA_ACTION_JSEL has no exception.
Method DISPLAY_STATS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | IT_RUNTIME_STATS | Call by reference | Type reference (TYPE) | ORA_JSEL_STATTAB | Runtime statistics data that has to be displayed | 20060131 |
Method DISPLAY_STATS on class CL_ORA_ACTION_JSEL has no exception.
Method FILL_VIEW_STRUCTURE Signature
Method FILL_VIEW_STRUCTURE on class CL_ORA_ACTION_JSEL has no parameter.
Method FILL_VIEW_STRUCTURE on class CL_ORA_ACTION_JSEL has no exception.
Method FREE_CONTROL_RESSOURCES Signature
Method FREE_CONTROL_RESSOURCES on class CL_ORA_ACTION_JSEL has no parameter.
Method FREE_CONTROL_RESSOURCES on class CL_ORA_ACTION_JSEL has no exception.
Method GET_JOB_DEFAULT_PARAMS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | E_BATCH_PRINT_CONTENT | Call by reference | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060118 | ||
2 | Exporting | E_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060118 | ||
3 | Exporting | E_BATCH_STMTID | Call by reference | Type reference (TYPE) | ORA_JSEL_STMT_ID | ID for an oracle 'arbitrary join select monitor' statement | 20060118 |
Method GET_JOB_DEFAULT_PARAMS on class CL_ORA_ACTION_JSEL has no exception.
Method GET_MAX_ID_COUNT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | P_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier of table ORA_SQLC_DATA | 20081209 | ||
2 | Returning | P_MAX_COUNT | Value transfer | Type reference (TYPE) | I | Max ID_COUNT for given ID of table ORA_SQLC_DATA | 20081209 |
Method GET_MAX_ID_COUNT on class CL_ORA_ACTION_JSEL has no exception.
Method GET_ORASID_CURRENT_WP Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | E_ORASID | Call by reference | Type reference (TYPE) | ORA_SID | Oracle SID for current workprocess | 20060118 | ||
2 | Exporting | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20060118 | ||
3 | Importing | I_ADBC_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Reference to ADBC connection for DB access | 20060118 |
Method GET_ORASID_CURRENT_WP on class CL_ORA_ACTION_JSEL has no exception.
Method GET_RESULT_TABLE Signature
Method GET_RESULT_TABLE on class CL_ORA_ACTION_JSEL has no parameter.
Method GET_RESULT_TABLE on class CL_ORA_ACTION_JSEL has no exception.
Method GET_SQL_STATEMENT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | ET_SQL_STATEMENT | Call by reference | Type reference (TYPE) | ORA_JSEL_TEXTTAB | SQL statement as text table | 20051219 | ||
2 | Exporting | E_SQL_STATEMENT | Call by reference | Type reference (TYPE) | STRING | SQL statement as string | 20051219 |
Method GET_SQL_STATEMENT on class CL_ORA_ACTION_JSEL has no exception.
Method GET_TIME_STATS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | ET_STATS | Call by reference | Type reference (TYPE) | ORA_JSEL_STATTAB | Time statistics table | 20060131 | ||
2 | Exporting | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20060131 | ||
3 | Importing | I_ADBC_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Reference to ADBC connection for DB access | 20060131 | ||
4 | Importing | I_ORASID | Call by reference | Type reference (TYPE) | ORA_SID | Oracle SID for current workprocess | 20060131 |
Method GET_TIME_STATS on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_CREATE_JOB Signature
Method OKCODE_CREATE_JOB on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_CREATE_JOB on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_DELE_STMT Signature
Method OKCODE_DELE_STMT on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_DELE_STMT on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_LOAD_STMT Signature
Method OKCODE_LOAD_STMT on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_LOAD_STMT on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_MONITOR_HELP Signature
Method OKCODE_MONITOR_HELP on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_MONITOR_HELP on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_PARSE Signature
Method OKCODE_PARSE on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_PARSE on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_PARSE_AND_EXEC Signature
Method OKCODE_PARSE_AND_EXEC on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_PARSE_AND_EXEC on class CL_ORA_ACTION_JSEL has no exception.
Method OKCODE_SAVE_STMT Signature
Method OKCODE_SAVE_STMT on class CL_ORA_ACTION_JSEL has no parameter.
Method OKCODE_SAVE_STMT on class CL_ORA_ACTION_JSEL has no exception.
Method PARSE_SQL_STATEMENT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Exporting | ET_COLUMNS | Call by reference | Type reference (TYPE) | TSQLPCOL | Table: columns within a parsed sql statement | 20051219 | ||
2 | Exporting | ET_TABLES | Call by reference | Type reference (TYPE) | TSQLPTABLES | Table: tables / views within a parsed sql statement | 20051219 | ||
3 | Exporting | E_RC | Value transfer | Type reference (TYPE) | I | Returncode, <> 0 if error occured | 20051219 | ||
4 | Importing | I_SQL_STATEMENT | Call by reference | Type reference (TYPE) | STRING | SQL statement to be parsed | 20051219 |
Method PARSE_SQL_STATEMENT on class CL_ORA_ACTION_JSEL has no exception.
Method SET_AND_CHECK_JOB_PARAMS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | I_BATCH_LDATE | Call by reference | Type reference (TYPE) | BTCLSDATE | Latest Execution Date for a Background Job | 20051228 | ||
2 | Importing | I_BATCH_LTIME | Call by reference | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20051228 | ||
3 | Importing | I_BATCH_PRIMM | Call by reference | Type reference (TYPE) | PRIMM2 | Print time | 20060113 | ||
4 | Importing | I_BATCH_PRINT_CONTENT | Call by reference | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060116 | ||
5 | Importing | I_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060116 | ||
6 | Importing | I_BATCH_SDATE | Call by reference | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20051228 | ||
7 | Importing | I_BATCH_STIME | Call by reference | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20051228 | ||
8 | Importing | I_BATCH_STMTID | Call by reference | Type reference (TYPE) | ORA_JSEL_STMT_ID | ID for an oracle 'arbitrary join select monitor' statement | 20051228 | ||
9 | Importing | I_BATCH_XIMMED | Call by reference | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20051228 | ||
10 | Importing | I_BATCH_XSTTIM | Call by reference | Type reference (TYPE) | XFELD | Flag: Batch execution at specified timestamp | 20051228 |
Method SET_AND_CHECK_JOB_PARAMS on class CL_ORA_ACTION_JSEL has no exception.
Method SPLIT_UP_INPUT_STRING Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Changing | P_SQL_STMT_TEXT | Call by reference | Type reference (TYPE) | STRING | Input: full text from Editor/Output: SQL Stmt text | 20081209 | ||
2 | Changing | P_TAB_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier for output table | 20081209 |
Method SPLIT_UP_INPUT_STRING on class CL_ORA_ACTION_JSEL has no exception.
Method SWITCH_TO_ENGLISH Signature
Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_JSEL has no parameter.
Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_JSEL has no exception.
History
Last changed by/on | SAP | 20130531 |
SAP Release Created in | 710 |