Hierarchy
⤷
⤷
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 | 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 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_ALV_GRID | ALV Grid | 20081209 | |||
| 2 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for Editor Control | 20081209 | |||
| 3 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for Editor Control | 20081209 | |||
| 4 | Constant | Private | Type reference (TYPE) | CHAR1 | '''' | Single-Character Flag | 20051220 | ||
| 5 | Constant | Private | Type reference (TYPE) | CHAR1 | 3 | Abort Batch Scheduling | 20051228 | ||
| 6 | Constant | Private | Type reference (TYPE) | CHAR1 | 2 | Enter new parameter values | 20051228 | ||
| 7 | Constant | Private | Type reference (TYPE) | CHAR1 | 1 | Run Job | 20051228 | ||
| 8 | Constant | Private | Type reference (TYPE) | DSQLPCOLTYPE | 1 | Column type "database field" | 20051220 | ||
| 9 | Constant | Private | Type reference (TYPE) | DSQLPCOLTYPE | 2 | Column type "expression" | 20051220 | ||
| 10 | Instance attribute | Private | Type reference (TYPE) | TT_RESULT | Global result table | 20081209 | |||
| 11 | Instance attribute | Private | Type reference (TYPE) | CHAR1 | Flag: Action after batch param. Popup | 20051228 | |||
| 12 | Instance attribute | Private | Type reference (TYPE) | BTCLSDATE | Latest Execution Date for a Background Job | 20051228 | |||
| 13 | Instance attribute | Private | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20051228 | |||
| 14 | Instance attribute | Private | Type reference (TYPE) | PRIMM2 | Print Time | 20060113 | |||
| 15 | Instance attribute | Private | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060116 | |||
| 16 | Instance attribute | Private | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060116 | |||
| 17 | Instance attribute | Private | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20051228 | |||
| 18 | Instance attribute | Private | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20051228 | |||
| 19 | Instance attribute | Private | Type reference (TYPE) | ORA_JSEL_STMT_ID | ID for an oracle 'arbitrary join select monitor' statement | 20051228 | |||
| 20 | Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20051228 | |||
| 21 | Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Batch execution at specified timestamp | 20051228 | |||
| 22 | Instance attribute | Private | Type reference (TYPE) | XFELD | Display of query result not allowed | 20060117 | |||
| 23 | Instance attribute | Private | Type reference (TYPE) | DB6NAVSYST | System Registration Table | 20051220 | |||
| 24 | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Reference to container (for editor) | 20051219 | |||
| 25 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_GUI_TEXTEDIT | Reference to editor | 20051219 | |||
| 26 | Instance attribute | Public | Object reference (TYPE REF TO) | CL_ORA_SRV_JSEL | Reference to instance with service methods | 20060116 | |||
| 27 | Instance attribute | Public | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20051219 | |||
| 28 | Instance attribute | Private | Attribute reference (LIKE) | 20100812 | |||||
| 29 | Instance attribute | Public | Type reference (TYPE) | ORACC_ACTION_JSEL | Data displayed | 20050912 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | Instance method | Private | Method | Check owner of tables that have to be read | 20051219 | |
| 2 | Instance method | Private | Method | Close ADBC connection (incl handling of exception) | 20060118 | |
| 3 | Instance method | Private | Method | Create ADBC connection for use in different DB accesses | 20060118 | |
| 4 | Instance method | Private | Method | Create and generate a subroutine pool containing the SQL | 20051219 | |
| 5 | Instance method | Private | Method | Display parse error message | 20051219 | |
| 6 | Instance method | Private | Method | Display statistics using ALV | 20060131 | |
| 7 | Instance method | Public | Method | Catch the request from the AWR Reporting Monitor | 20100812 | |
| 8 | Instance method | Private | Method | Free all control ressources | 20051219 | |
| 9 | Instance method | Public | Method | Get default values for job parameters of current statement | 20060118 | |
| 10 | Instance method | Public | Method | Get the max ID_COUNT for given ID of table ORA_SQLC_DATA | 20081209 | |
| 11 | Instance method | Private | Method | Get oracle SID for current SAP workprocess | 20060118 | |
| 12 | Instance method | Private | Method | Get the result of the SQL query from generated program | 20081209 | |
| 13 | Instance method | Public | Method | Get SQL statement from editor | 20051219 | |
| 14 | Instance method | Private | Method | Get current runtime statistics information | 20060131 | |
| 15 | Instance method | Private | Method | Create a batch job for statement execution | 20060118 | |
| 16 | Instance method | Private | Method | Delete SQL statement from database | 20051222 | |
| 17 | Instance method | Private | Method | Load SQL statement from database | 20051222 | |
| 18 | Instance method | Private | Method | Display monitor help (call knowledge warehouse) | 20060301 | |
| 19 | Instance method | Public | Method | Parse the edited SQL statement | 20051219 | |
| 20 | Instance method | Public | Method | Parse and Execute the edited SQL statement | 20051219 | |
| 21 | Instance method | Private | Method | Save SQL statement to database | 20051222 | |
| 22 | Instance method | Private | Method | Parse SQL statement,get result columns and tables to be read | 20051219 | |
| 23 | Instance method | Public | Method | Set attributes for job parameters and check them | 20051228 | |
| 24 | Instance method | Public | Method | Determine the identifier for output table | 20081209 | |
| 25 | 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 | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20051219 | |||
| 2 | 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 | 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 | 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 | E_RC | Call by reference | Type reference (TYPE) | I | <> 0 if error occured | 20051219 | |||
| 2 | E_SQL_REPORT | Call by reference | Type reference (TYPE) | PROGNAME | ABAP Program Name, generated report | 20051219 | |||
| 3 | IT_COLUMNS | Call by reference | Type reference (TYPE) | TSQLPCOL | list of columns to read in the statement | 20051219 | |||
| 4 | IT_TABLES | Call by reference | Type reference (TYPE) | TSQLPTABLES | list of tables used in the statement | 20051219 | |||
| 5 | I_SQL_STATEMENT | Call by reference | Type reference (TYPE) | STRING | SQL statement | 20051219 | |||
| 6 | P_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier of table ORA_SQLC_DATA | 20081209 | |||
| 7 | 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 | 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 | 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 | E_BATCH_PRINT_CONTENT | Call by reference | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060118 | |||
| 2 | E_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060118 | |||
| 3 | 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 | P_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier of table ORA_SQLC_DATA | 20081209 | |||
| 2 | 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 | E_ORASID | Call by reference | Type reference (TYPE) | ORA_SID | Oracle SID for current workprocess | 20060118 | |||
| 2 | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20060118 | |||
| 3 | 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 | ET_SQL_STATEMENT | Call by reference | Type reference (TYPE) | ORA_JSEL_TEXTTAB | SQL statement as text table | 20051219 | |||
| 2 | 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 | ET_STATS | Call by reference | Type reference (TYPE) | ORA_JSEL_STATTAB | Time statistics table | 20060131 | |||
| 2 | E_RC | Call by reference | Type reference (TYPE) | I | Result: <> 0 if at least one table is not allowed | 20060131 | |||
| 3 | I_ADBC_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Reference to ADBC connection for DB access | 20060131 | |||
| 4 | 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 | ET_COLUMNS | Call by reference | Type reference (TYPE) | TSQLPCOL | Table: columns within a parsed sql statement | 20051219 | |||
| 2 | ET_TABLES | Call by reference | Type reference (TYPE) | TSQLPTABLES | Table: tables / views within a parsed sql statement | 20051219 | |||
| 3 | E_RC | Value transfer | Type reference (TYPE) | I | Returncode, <> 0 if error occured | 20051219 | |||
| 4 | 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 | I_BATCH_LDATE | Call by reference | Type reference (TYPE) | BTCLSDATE | Latest Execution Date for a Background Job | 20051228 | |||
| 2 | I_BATCH_LTIME | Call by reference | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20051228 | |||
| 3 | I_BATCH_PRIMM | Call by reference | Type reference (TYPE) | PRIMM2 | Print time | 20060113 | |||
| 4 | I_BATCH_PRINT_CONTENT | Call by reference | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20060116 | |||
| 5 | I_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20060116 | |||
| 6 | I_BATCH_SDATE | Call by reference | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20051228 | |||
| 7 | I_BATCH_STIME | Call by reference | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20051228 | |||
| 8 | I_BATCH_STMTID | Call by reference | Type reference (TYPE) | ORA_JSEL_STMT_ID | ID for an oracle 'arbitrary join select monitor' statement | 20051228 | |||
| 9 | I_BATCH_XIMMED | Call by reference | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20051228 | |||
| 10 | 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 | P_SQL_STMT_TEXT | Call by reference | Type reference (TYPE) | STRING | Input: full text from Editor/Output: SQL Stmt text | 20081209 | |||
| 2 | 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 |