SAP ABAP Class CL_ORA_ACTION_JSEL (ORA: SQL Command Editor)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   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