Hierarchy

⤷

⤷

Meta Relationship - Using
# | Relationship type | Using | Short Description | Created on |
---|---|---|---|---|
1 | Interface implementation (CLASS c. INTERFACES i_ref) | IF_RSDRS_SQL_STMT | Data Manager SQL Statement | 20050117 |
Properties
Class | CL_RSDRS_DB400_SQL_STMT | |
Short Description | Generate a DB4 SQL Statement | |
Super Class | ||
Instantiability of a Class | 2 | Public |
Final |
General Data
Message Class | ||
Program status | ||
Category | 0 | |
Package | RSDB4 | SAP NW BW on IBM i (DB4) |
Created | 20050117 | 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) |
2 | ![]() |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
3 | ![]() |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
4 | ![]() |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
# | Interface | Abstract | Final | Description | Created on |
---|---|---|---|---|---|
1 | IF_RSDRS_SQL_STMT | Data Manager SQL Statement | 20050117 |
Friends
# | Friend | Modeled only | Created on | Description |
---|---|---|---|---|
1 | CL_RSDRS_DB400_EXITS | 20050117 | Database dependent exits for DB400 |
Attributes
# | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RSDRS_ACCESSTP | Access type of statement | 20050117 | ||
2 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RSD_TABLNM | View of union all Table | 20050117 | ||
3 | ![]() |
Instance attribute | Private | Type reference (TYPE) | STRING | correction factor for unambiguous hierarchies | 20050117 | ||
4 | ![]() |
Instance attribute | Private | Type reference (TYPE) | I | 0 | Package size for selective deletion | 20120308 | |
5 | ![]() |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_RSDRS_DB400_EXITS | Reference to Database specific exits | 20050117 | ||
6 | ![]() |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_RSDRS_STMT_SRVS | Service Object for Statement Creation | 20050117 | ||
7 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RSDRS_SX_QUERY | query definition | 20050117 | ||
8 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Generated Code | 20050117 | ||
9 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | Use DB optimizer features | 20050117 | ||
10 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | RS_C_UNKNOWN | Use factview in queries | 20050422 | |
11 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RS_BOOL | Use GROUPING SETS Yes/No | 20081211 | ||
12 | ![]() |
Instance attribute | Private | Type reference (TYPE) | RSD_TABLNM | Name of generated View | 20050124 |
Methods
# | Method | Level | Visibility | Method type | Description | Created on |
---|---|---|---|---|---|---|
1 | ![]() |
Instance method | Private | Method | build an entry of char. and nav. attr. part of select list | 20050117 |
2 | ![]() |
Instance method | Private | Method | For db_delete build delete header | 20050901 |
3 | ![]() |
Instance method | Private | Method | Build subquery for package-wise deletion | 20120308 |
4 | ![]() |
Instance method | Private | Method | Build starting select list for factview | 20050117 |
5 | ![]() |
Instance method | Private | Method | Build the final orderby clause for the factview | 20050117 |
6 | ![]() |
Instance method | Private | Method | Build starting select list for factview | 20050117 |
7 | ![]() |
Instance method | Private | Method | Build an entry of char. and nav. attr. part of select list | 20071121 |
8 | ![]() |
Instance method | Private | Method | Build the from list with join conditions (ANSI Notation) | 20050117 |
9 | ![]() |
Instance method | Private | Method | Build group by part of statement | 20050117 |
10 | ![]() |
Instance method | Private | Method | Build the have list (not used currently) | 20050117 |
11 | ![]() |
Instance method | Protected | Method | build hint for SQL stmt | 20050117 |
12 | ![]() |
Instance method | Private | Method | For db_insert or db_create build insert list, drop indexes | 20050117 |
13 | ![]() |
Instance method | Private | Method | Build Select List Entry for a Key Figure | 20050117 |
14 | ![]() |
Instance method | Private | Method | build order by list | 20050117 |
15 | ![]() |
Instance method | Private | Method | build a single outer join condition | 20050117 |
16 | ![]() |
Instance method | Private | Method | build a subquery. Subqueries may occur within where cond. | 20050117 |
17 | ![]() |
Instance method | Private | Method | Build SELECT clause for top/bottom query | 20081211 |
18 | ![]() |
Instance method | Private | Method | Build WHERE clause for top/bottom query | 20081211 |
19 | ![]() |
Instance method | Private | Method | Build the where list (without the join part) | 20050117 |
20 | ![]() |
Instance method | Public | Constructor | Class constructor | 20050117 |
21 | ![]() |
Instance method | Private | Method | Drops a primary key | 20050117 |
22 | ![]() |
Instance method | Private | Method | Determine the correction factor for unambiguous hierarchies | 20050117 |
23 | ![]() |
Instance method | Private | Method | Changes the factview into two union all connected star joins | 20050117 |
24 | ![]() |
Instance method | Private | Method | Get number of dimensions with select options | 20050117 |
25 | ![]() |
Instance method | Private | Method | Get starting table for join conditions | 20050117 |
26 | ![]() |
Instance method | Private | Method | Changes the factview into two union all connected star joins | 20050117 |
27 | ![]() |
Instance method | Private | Method | Processes Top/Bottom Query | 20060217 |
28 | ![]() |
Instance method | Private | Method | Splits statement into header and select stmt | 20060217 |
29 | ![]() |
Instance method | Private | Method | recurse over from list and join tables together | 20050117 |
30 | ![]() |
Instance method | Private | Method | Replace LIKE with SUBSTR if possible | 20070320 |
31 | ![]() |
Instance method | Private | Method | write a table entry of the from list | 20050117 |
Events
Class CL_RSDRS_DB400_SQL_STMT has no event.
Types
Class CL_RSDRS_DB400_SQL_STMT has no local type.
Method Signatures
Method BUILD_CHA_SELECT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_SEPARATOR | Call by reference | Type reference (TYPE) | RSDRS_SEP | Separator between list elements | 20050117 | ||
2 | ![]() |
I_S_CHA | Call by reference | Type reference (TYPE) | RSDRS_S_CHA | actual characteristic to build entry for | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_DELETE_HEADER Signature
Method BUILD_DELETE_HEADER on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20050901 |
Method BUILD_DELETE_NROWS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_T_WHERE_CODE | Call by reference | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | 20120308 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20120308 |
Method BUILD_FACTVIEW_HAVING Signature
Method BUILD_FACTVIEW_HAVING on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20050117 |
Method BUILD_FACTVIEW_ORDERBY Signature
Method BUILD_FACTVIEW_ORDERBY on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20050117 |
Method BUILD_FACTVIEW_SELECT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
R_GROUPBY | Value transfer | Type reference (TYPE) | RS_BOOL | Groupby Needed ? | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20050117 |
Method BUILD_FORMULA Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_FORMULA | Call by reference | Type reference (TYPE) | RSDRS_S_KYF-FORMULA | formula | 20071121 | ||
2 | ![]() |
I_T_FORM_FLD | Call by reference | Type reference (TYPE) | RSDRS_T_FORM_FLD | factor for unambigous hierarchies | 20071121 | ||
3 | ![]() |
R_FORMULA | Value transfer | Type reference (TYPE) | STRING | Resolved Formula | 20071121 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20071121 |
Method BUILD_FROM_JOINS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_TH_JOIN | Call by reference | Type reference (TYPE) | RSDRS_TH_JOIN | List of inner join conditions | 20050117 | ||
2 | ![]() |
I_TH_TABLE | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | Table List | 20050117 | ||
3 | ![]() |
I_TX_LEFTOUTER | Call by reference | Type reference (TYPE) | RSDRS_TX_LEFTOUTER | list of left outer joins | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_GROUPBY_LIST Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_T_GROUPBY | Call by reference | Type reference (TYPE) | RSDRS_T_GROUPBY | Groupby | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_HAVING_LIST Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_T_HAVING | Call by reference | Type reference (TYPE) | RSDRS_T_HAVING | Having list | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_HINT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
E_HINT | Call by reference | Type reference (TYPE) | RS_CHAR255 | Final hints ... | 20050117 | ||
2 | ![]() |
I_OPEN_SQL | Call by reference | Type reference (TYPE) | RS_BOOL | Boolean | 20050117 | ||
3 | ![]() |
I_T_HINT | Call by reference | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Hints from Statement (if set ...) | 20050117 |
Method BUILD_HINT on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method BUILD_INSERT_HEADER Signature
Method BUILD_INSERT_HEADER on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_KYF_SELECT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_HIER_FACTOR | Call by reference | Type reference (TYPE) | STRING | factor for unambigous hierarchies | 20050117 | ||
2 | ![]() |
I_SEPARATOR | Call by reference | Type reference (TYPE) | RSDRS_SEP | Separator for select list | 20050117 | ||
3 | ![]() |
I_S_KYF | Call by reference | Type reference (TYPE) | RSDRS_S_KYF | key figure description | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_ORDERBY Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_T_ORDERBY | Call by reference | Type reference (TYPE) | RSDRS_T_ORDERBY | orderby list | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_OUTER Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
C_TH_TBLS_JOINED | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | Tables already joined | 20050117 | ||
2 | ![]() |
I_SX_LEFTOUTER | Call by reference | Type reference (TYPE) | RSDRS_SX_LEFTOUTER | left outer condition to build | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_SUBQUERY Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_SUBQUERY_ID | Call by reference | Type reference (TYPE) | RSDRS_SUBQUERY_ID | Subquery ID of actual subquery | 20050117 | ||
2 | ![]() |
I_SX_SUBQUERY | Call by reference | Type reference (TYPE) | RSDRS_SX_SUBQUERY | Subquery description | 20050117 | ||
3 | ![]() |
I_S_WHERE | Call by reference | Type reference (TYPE) | RSDRS_S_WHERE | Surrounding where statement | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method BUILD_TOP_SELECT Signature
Method BUILD_TOP_SELECT on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20081211 |
Method BUILD_TOP_WHERE Signature
Method BUILD_TOP_WHERE on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20081211 |
Method BUILD_WHERE_LIST Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_SUBQUERY_ID | Call by reference | Type reference (TYPE) | RSDRS_SUBQUERY_ID | ID of actual subquery | 20050117 | ||
2 | ![]() |
I_T_WHERE | Call by reference | Type reference (TYPE) | RSDRS_T_WHERE | Where List | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method CONSTRUCTOR Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_SX_QUERY | Call by reference | Type reference (TYPE) | RSDRS_SX_QUERY | Quey description | 20050117 |
Method CONSTRUCTOR on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method DB400_DROP_PRIMARY_KEY Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_TABLNM | Call by reference | Type reference (TYPE) | RSDRS_RETURNOBJ | 20050117 |
Method DB400_DROP_PRIMARY_KEY on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method DET_HIER_FACTOR Signature
Method DET_HIER_FACTOR on class CL_RSDRS_DB400_SQL_STMT has no parameter.
Method DET_HIER_FACTOR on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method FIND_FACTVIEW Signature
Method FIND_FACTVIEW on class CL_RSDRS_DB400_SQL_STMT has no parameter.
Method FIND_FACTVIEW on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method GET_SELDIM Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
I_THRESHOLD | Call by reference | Type reference (TYPE) | I | Min. number of selective dimensions needed | 20050117 | ||
2 | ![]() |
R_SEL_DIM | Value transfer | Type reference (TYPE) | I | Number of selective dimensions | 20050117 |
Method GET_SELDIM on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method GET_STARTTAB Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
E_STARTTAB | Value transfer | Type reference (TYPE) | RSDRS_ALIAS | Starting table | 20050117 | ||
2 | ![]() |
I_TH_TABLE | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | Table list to find starttab in | 20050117 |
Method GET_STARTTAB on class CL_RSDRS_DB400_SQL_STMT has no exception.
Method PROCESS_FACTVIEW Signature
Method PROCESS_FACTVIEW on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20050117 |
Method PROCESS_TOPQUERY Signature
Method PROCESS_TOPQUERY on class CL_RSDRS_DB400_SQL_STMT has no parameter.
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20060217 |
Method SPLIT_HEADER Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
C_T_CODE | Call by reference | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Statement without header | 20060217 | ||
2 | ![]() |
E_T_HEADER | Call by reference | Type reference (TYPE) | RSDRS_T_ABAPSOURCE | Header | 20060217 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20060217 |
Method WRITE_JOIN Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
C_TH_TBLS_JOINED | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | Tables that have already been joined | 20050117 | ||
2 | ![]() |
C_TS_JOIN | Call by reference | Type reference (TYPE) | RSDRS_TS_JOIN | Join list to work on | 20050117 | ||
3 | ![]() |
I_STARTTAB | Call by reference | Type reference (TYPE) | RSDRS_ALIAS | Table to start with | 20050117 | ||
4 | ![]() |
I_TH_TABLE | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | List of Tables | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
Method WRITE_LIKE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
E_REPLACED | Call by reference | Type reference (TYPE) | RS_BOOL | LIKE was replaced with SUBSTR? | 20070320 | ||
2 | ![]() |
I_S_WHERE | Call by reference | Type reference (TYPE) | RSDRS_S_WHERE | where condition | 20070320 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
Generated Stmt is too long ... | 20070322 |
Method WRITE_TABLE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
C_TH_TBLS_JOINED | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | tables already joined | 20050117 | ||
2 | ![]() |
I_TABALIAS | Call by reference | Type reference (TYPE) | RSDRS_ALIAS | alias of table to write | 20050117 | ||
3 | ![]() |
I_TH_TABLE | Call by reference | Type reference (TYPE) | RSDRS_TH_TABLE | list of tables | 20050117 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | ![]() |
SQL-Statement ist zu groß | 20050117 |
History
Last changed by/on | SAP | 20130531 |
SAP Release Created in | 700 |