SAP ABAP Class CL_ORA_ACTION_SQL_EDITOR (ORA: General SQL Command Editor)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle MonitorsMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DBA_ACTION_SQL_EDITOR | DB6: CLP Command Processing | 20110809 |
Properties
| Class | CL_ORA_ACTION_SQL_EDITOR | |
| Short Description | ORA: General SQL Command Editor | |
| Super Class | CL_DBA_ACTION_SQL_EDITOR | DB6: CLP Command Processing |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | S_ORA_COCKPIT | DBACockpit: Oracle Monitors |
| Created | 20110809 | SAP |
| Last change | 20130531 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_ORA_ACTION_SQL_EDITOR has no forward declaration.
Interfaces
Class CL_ORA_ACTION_SQL_EDITOR has no interface implemented.
Friends
Class CL_ORA_ACTION_SQL_EDITOR has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | GC_BA_ABORT |
Constant | Private | Type reference (TYPE) | CHAR1 | 3 | Abort Batch Scheduling | 20110812 | |
| 2 | GC_BA_REENTER |
Constant | Private | Type reference (TYPE) | CHAR1 | 2 | Enter new parameter values | 20110812 | |
| 3 | GC_BA_RUNJOB |
Constant | Private | Type reference (TYPE) | CHAR1 | 1 | Run Job | 20110812 | |
| 4 | G_BATCH_ACTION |
Instance attribute | Public | Type reference (TYPE) | CHAR1 | Flag: Action after batch param. Popup | 20110812 | ||
| 5 | G_BATCH_LDATE |
Instance attribute | Private | Type reference (TYPE) | BTCLSDATE | Latest Execution Date for a Background Job | 20110812 | ||
| 6 | G_BATCH_LTIME |
Instance attribute | Private | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20110812 | ||
| 7 | G_BATCH_PRIMM |
Instance attribute | Public | Type reference (TYPE) | PRIMM2 | Print Time | 20110812 | ||
| 8 | G_BATCH_PRINT_CONTENT |
Instance attribute | Private | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20110812 | ||
| 9 | G_BATCH_PRINT_RT_STAT |
Instance attribute | Private | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20110812 | ||
| 10 | G_BATCH_SDATE |
Instance attribute | Private | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20110812 | ||
| 11 | G_BATCH_STIME |
Instance attribute | Private | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20110812 | ||
| 12 | G_BATCH_STMTID |
Instance attribute | Private | Type reference (TYPE) | ORA_JSEL_STMT_ID | D for an select monitor statement | 20110812 | ||
| 13 | G_BATCH_XIMMED |
Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20110812 | ||
| 14 | G_BATCH_XSTTIM |
Instance attribute | Private | Type reference (TYPE) | XFELD | Flag: Batch execution at specified timestamp | 20110812 | ||
| 15 | G_CONTENT_NOT_ALLOWED |
Instance attribute | Private | Type reference (TYPE) | XFELD | Display of query result not allowed | 20110812 | ||
| 16 | G_REMOTE_SYSTEM |
Instance attribute | Private | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110812 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | GET_JOB_DEFAULT_PARAMS |
Instance method | Public | Method | Get default values for job parameters of current statement | 20110812 |
| 2 | GET_STMT_DETAILS |
Instance method | Private | Method | Get details of the stmt execution | 20110811 |
| 3 | OKCODE_CREATE_JOB |
Instance method | Private | Method | Create a batch job for statement execution | 20110812 |
| 4 | OKCODE_EXPLAIN_STMT |
Instance method | Private | Method | Explain SQL Statement | 20110811 |
| 5 | SET_AND_CHECK_JOB_PARAMS |
Instance method | Public | Method | Set attributes for job parameters and check them | 20110812 |
| 6 | SPLIT_UP_INPUT_STRING |
Instance method | Private | Method | Determine the identifier for output table | 20110812 |
| 7 | SQL_PARSE_STMT |
Instance method | Private | Method | DBMS_SQL: Parse the SQL Stmt | 20110811 |
Events
Class CL_ORA_ACTION_SQL_EDITOR has no event.
Types
Class CL_ORA_ACTION_SQL_EDITOR has no local type.
Method Signatures
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) | 20110812 | ||
| 2 | Exporting |
E_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20110812 |
Method GET_JOB_DEFAULT_PARAMS on class CL_ORA_ACTION_SQL_EDITOR has no exception.
Method GET_STMT_DETAILS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
P_ORA_PAR | Call by reference | Type reference (TYPE) | ORAEXPLPAR | Parameter for Explain from v$sql_plan | 20110811 | ||
| 2 | Exporting |
P_RC | Call by reference | Type reference (TYPE) | I | return code | 20110811 | ||
| 3 |  Importing |
P_VMARKER | Call by reference | Type reference (TYPE) | STRING | marker string | 20110811 |
Method GET_STMT_DETAILS on class CL_ORA_ACTION_SQL_EDITOR has no exception.
Method OKCODE_CREATE_JOB Signature
Method OKCODE_CREATE_JOB on class CL_ORA_ACTION_SQL_EDITOR has no parameter.
Method OKCODE_CREATE_JOB on class CL_ORA_ACTION_SQL_EDITOR has no exception.
Method OKCODE_EXPLAIN_STMT Signature
Method OKCODE_EXPLAIN_STMT on class CL_ORA_ACTION_SQL_EDITOR has no parameter.
Method OKCODE_EXPLAIN_STMT on class CL_ORA_ACTION_SQL_EDITOR 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 | 20110812 | ||
| 2 | Importing |
I_BATCH_LTIME | Call by reference | Type reference (TYPE) | BTCLSTIME | Latest Execution Time for Background Job | 20110812 | ||
| 3 | Importing |
I_BATCH_PRIMM | Call by reference | Type reference (TYPE) | PRIMM2 | Print time | 20110812 | ||
| 4 | Importing |
I_BATCH_PRINT_CONTENT | Call by reference | Type reference (TYPE) | XFELD | Print result of SQL statement (=content) | 20110812 | ||
| 5 | Importing |
I_BATCH_PRINT_RT_STAT | Call by reference | Type reference (TYPE) | XFELD | Print runtime analysis for SQL statement | 20110812 | ||
| 6 | Importing |
I_BATCH_SDATE | Call by reference | Type reference (TYPE) | BTCSDATE | Planned Start Date for Background Job | 20110812 | ||
| 7 | Importing |
I_BATCH_STIME | Call by reference | Type reference (TYPE) | BTCSTIME | Planned start time for background Job | 20110812 | ||
| 8 | Importing |
I_BATCH_XIMMED | Call by reference | Type reference (TYPE) | XFELD | Flag: Immediate batch execution | 20110812 | ||
| 9 | Importing |
I_BATCH_XSTTIM | Call by reference | Type reference (TYPE) | XFELD | Flag: Batch execution at specified timestamp | 20110812 |
Method SET_AND_CHECK_JOB_PARAMS on class CL_ORA_ACTION_SQL_EDITOR 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 | 20110812 | ||
| 2 | Changing |
P_TAB_IDENTIFIER | Call by reference | Type reference (TYPE) | STRING | Identifier for output table | 20110812 |
Method SPLIT_UP_INPUT_STRING on class CL_ORA_ACTION_SQL_EDITOR has no exception.
Method SQL_PARSE_STMT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
P_SQL_STMT | Call by reference | Type reference (TYPE) | STRING | Input SQL Statement as string | 20110811 | ||
| 2 | Importing |
P_VMARKER | Call by reference | Type reference (TYPE) | STRING | marker string | 20110811 |
Method SQL_PARSE_STMT on class CL_ORA_ACTION_SQL_EDITOR has no exception.
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 732 |
