public java.lang.String getModel(java.lang.String pPropertyName)
This method returns information on the current data model during the processing of a personalized reverse engineering. The list of available data is described in the pPropertyName values table.
Note: This method may be used on the source connection (data server being reverse-engineered) as well as on the target connection (odi repository). On the target connection, only the properties independent from the context can be specified (for example, the schema and catalog names cannot be used)
|
Parameter |
Type |
Description |
|---|---|---|
|
pPropertyName |
String |
String that contains the name of the requested property. |
The following table lists the possible values for pPropertyName:
|
Parameter value |
Description |
|---|---|
|
ID |
Internal identifier of the current model |
|
MOD_NAME |
Name of the current model |
|
LSCHEMA_NAME |
Name of the logical schema of the current model |
|
MOD_TEXT |
Description of the current model |
|
REV_TYPE |
Reverse engineering type: S for standard reverse, C for customize |
|
REV_UPDATE |
Update flag of the model |
|
REV_INSERT |
Insert flag for the model |
|
REV_OBJ_PATT |
Mask for the objects to reverse. |
|
REV_OBJ_TYPE |
List of object types to reverse-engineer for this model. This is a semicolon separated list of object types codes. Valid codes are:
|
|
TECH_INT_NAME |
Internal name of the technology of the current model. |
|
LAGENT_NAME |
Name of the logical execution agent for the reverse engineering. |
|
REV_CONTEXT |
Execution context of the reverse |
|
REV_ALIAS_LTRIM |
Characters to be suppressed for the alias generation |
|
CKM |
Check Knowledge Module |
|
RKM |
Reverse-engineering Knowledge Module |
|
SCHEMA_NAME |
Physical Name of the data schema in the current reverse context |
|
WSCHEMA_NAME |
Physical Name of the work schema in the current reverse context |
|
CATALOG_NAME |
Physical Name of the data catalog in the current reverse context |
|
WCATALOG_NAME |
Physical Name of the work catalog in the current reverse context |
|
<flexfield code> |
Value of the flexfield for the current model. |
Retrieve the list of tables that are part of the mask of objects to reverse:
select TABLE_NAME,
RES_NAME,
replace(TABLE_NAME, '<%=odiRef.getModel("REV_ALIAS_LTRIM")%>' , '') ALIAS,
TABLE_DESC
from MY_TABLES
where
TABLE_NAME like '<%=odiRef.getModel("REV_OBJ_PATT")%>'